Sub-Reports with No Data (1 Viewer)

[Val]

I have a report that has 4 sub-reports in it. When the report is run there may or may no be data for any of the 4 sub-reports. How do I print a message that says "No data at this time" for any of the sub-reports that have no data, but still print the ones that do? The report has to include a page for each sub-report.

Any suggestions would be apprecitated!!

 

[Travis]

Add hidden text boxes behind the sub report. On the Open Event of the main form determine by getting a record count (RecordSourceClone.Count) if they have any records. Hide the Sub Report and make the corresponding Label Visible.

 

[Clarence]

As an add on to the reply from TRAVIS you can achieve the control over the hidden text box by using the ON NODATA event in the report. this saves the complication of counting the records