report problem

[jonudden]

I have a report and in that report are 5 subreports. If there is n
data on one of the subreports then it leaves a blank spot on th
whole report. I would like to have a lbl that states no data found i
there is no data on the report. I can't figure out how to call tha
label up in the no data found section. Any thoughts

 

[Allen Browne]

Use a text box, and test the HasData property of the report in the subreport
control.

The Control Source of the text box will be:
=IIf([Sub1].[Report].[HasData], Null, "No data")
Replace "Sub1" with the name of your subreport control.