Print a text message to indicate no records in sub report

[Syspol Consultants]

Hope I can explain my problem.
I have a main report for a number of sites.
It has 5 sub reports some of which may not contain data for a particular site.
Would like to indicate on the report that there is no data for this site on
this sub report.

 

[Allen Browne]

Create a text box on the main report, and set its Control Source to
something like this:
=IIf([Sub1].[Report].[HasData], Null, "Nothing for this site.")

Replace Sub1 with the name of your subreport control.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...