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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top