Display message for blank subreport

[carriey]

I have a report with 13 subreports. Each one contains specific information
about a type of problem or application that could relate to the main record
(a location).

I have put the title for each subreport on to the Report itself and then of
course, if there is no information for that specific subreport, there is a
blank space before the next one.

What I would actually like is for a message to display that says something
like "No issue currently exists for xxxx (being the type of issue), or no
data has been recorded".

I am sure there is an easy way to do this but I haven't had any luck
searching. Any advice is appreciated!

 

[Allen Browne]

Test the HasData property of the report in the subreport control.

Place a text box on the main report in the same section as the subreport.
Set its Control Source to an expression such as this:
=IIf([Sub1].[Report].[HasData], Null, "No issue exists for Sub1.")

Substitute the name of your subreport control for Sub1.