Hopefully this will be a fairly simple one....
I have a report containing a sub-report, e.g:
Category 1 details
Category 4 details
Category 7 details
I need to have an optional page in the report if a particular Category is present, say 4 in this example.
What is the best way to check the sub-report recordset to see if Category 4 is present (it won't always be) - do I need to loop thru the recordset when the report is opened to check if there is a Category 4 record or is there an easier way to do this?