If subreport has no data return "None"

[Ben]

Is it possible to somehow code a subreport to return the value "None" in a
Label if the tables in a subreport are blank?

I have a subreport called Security. If no data is entered I would like the
report to just show "None" or "N/A" or something like that.

Make sense?

 

[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([Security].[Report].[HasData], Null, "None")