Help with report

  • Thread starter Thread starter SF
  • Start date Start date
S

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
 
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")
 
Back
Top