Help with report

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
 
A

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering subreports on main report 0
Have to click on report to show sub report 2
Can sub-report parameters vary by main report values per page? 3
Print report and subreport(no data) without blank page 0
Gouping In Sub Reports Leaving Windowed Headings 2
Hide Sub Report(s) when records are null 6
Page break between sub reports of a sub report 1
Hiding/Displaying a Sub-report 1

Top