Group By Yes/No In Report Question

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!
 
K

Klatuu

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.
 
N

NFL

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...
 
Top