I need to combine several reports into one report with the only relationship being departmental managers; a combined report may have from zero to nine subreports. When the report has no subreports a blank page is printed for the manager having only a page header and footer. I tried using the .HasData and .NoData events but, since the main report is unbound, these events aren't applicable. Due to the diversity of the subreports, a query to select only managers having subreports would be extremely large and complex.

Is there a simple way to prevent a page from printing when no subreports are associated with a manager?

Thanks,
Michael