Print Report If Sub-Report Has Data

  • Thread starter Thread starter Ripper
  • Start date Start date
R

Ripper

I have a series of reports that I only need to print if their sub-report has
data in it. If there is not sub-report data I don't need to print the
report. Pretty standard report based on a query made at the report.
Sub-Report based on a table that filters out results specific to that report.
 
I would use some code to query/count the subrecords prior to even opening the
report.
 
Thanks for the idea. I creaded a query that counted the active session ids
from the subquery table and linked that to the table where the session data
is stored. Now the query only shows the records where there is data in the
subquery.
 
Back
Top