If subreport has no data return "None"

  • Thread starter Thread starter Ben
  • Start date Start date
B

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