On No Data event for Report made up of 3 SubReports

[David Ball]

Hi,
I have three reports that I have used as the subreports for one master report. The master report shows the three subreports on a page.
When one or more of the subreports contains no data the master report still shows the empty subreport. I would like subreports with no data to be left off the master report if this is possible.
For each of the individual subreports I have used the On No Data event to display a message and then not open the report if there is no data. This works fine for the individual subreports but when I open the master report the “empty” subreport is still displayed.
Is there a way to leave the subreport off the master report when there is no data in the subreport?
Thanks very much
Dave

 

[JHB]

...
Is there a way to leave the subreport off the master report when there is no data in the subreport?

No, you can only add or delete controls in design view, but you can hide them, (Visible = True/False).