controlling the appearance of data

  • Thread starter Thread starter G.
  • Start date Start date
G

G.

I have a main report with 3 sub reports in it. Each sub report is based on a
query. If there is no data on a particular person in one of the 3 subreport
queries, the subreport contents do not show up on the main report - and vice
versa. This is what I want.

My question is how can I get the space where the subreport contents usually
shows up to just say something like "No Data Available" if that is the case?
Thank you.
 
G. said:
I have a main report with 3 sub reports in it. Each sub report is based on a
query. If there is no data on a particular person in one of the 3 subreport
queries, the subreport contents do not show up on the main report - and vice
versa. This is what I want.

My question is how can I get the space where the subreport contents usually
shows up to just say something like "No Data Available" if that is the case?
Thank you.
Click to expand...


Create a label control (named lblrpt1) and place it in
subreport1's area. Set its Caption to whatever you want.

Then add a line of code to the section's Format event
procedure:
Me.lblrpt1.Visible = Not Me.subreport1.Report.HasData

Trpeat for the other subreports.
 
Back
Top