Group By Yes/No In Report Question

  • Thread starter Thread starter NFL
  • Start date Start date
N

NFL

Is there a way that I can group reports by conditions? I would like to group
my report based on what is completed and what is not completed. Every record
has an option to check yes or no. The checkboxes would be used for (if
completed.. then check yes --- if not completed then check no)

Thank you!
 
Just create a group in the sorting/grouping on that field.
Create a Group Header for it.
Since True = -1 and False = 0, Records with False will be grouped first. If
you want the Trues to be first, set the grouping options to sort descending.
 
Thank you!

Klatuu said:
Just create a group in the sorting/grouping on that field.
Create a Group Header for it.
Since True = -1 and False = 0, Records with False will be grouped first. If
you want the Trues to be first, set the grouping options to sort descending.
Click to expand...
 
Back
Top