Help with report

[SF]

Hi,

I have a main report with several sub reports to display data from deffirent
source for each selected reports. When I open the main report, some sub
reports did not have the data for display (or report did not display/blank).
Is there a way to identify the sub report name and display a line say "No
Report" or "No Data"?

SF

 

[Allen Browne]

If you sub report is named Sub1, put a text box on the main report (in the
same section), and set its Control Source to:
=IIf([Sub1].[Report].[HasData], Null, "No Report")