Omitting records based on a checkbox...
The database I'm working on has a report that shows earning of each artist type associated with the company.
For example: Photographer, Stylist, Makup.
The users wants the ability to omit an artist type when running the report.
I want to have a checkbox for each artist type. When checked the artist type is omitted from the report.
if [Invoices::Photographer Omit Checkbox = "Yes"]
Constrain Found Set (set to omit photographers)
The Constrain Found Set part works regardless of the checkbox being checked or not.
I basically want to turn "Constrain Found Set" on or off based on the checkbox..