Subreport with no data.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subreport that will have no data sometimes. I would still like the labels to show up even if there is no data from the query. How can I do this

Thanks
 
Josh said:
I have a subreport that will have no data sometimes. I would still like the labels to show up even if there is no data from the query. How can I do this?
Click to expand...


Place the controls you want to appear (when the subreport is
empty) on the main report in the same area as the subreport.

Then use code in the Format event of the main report section
that contains the subreport to make those controls visible
or not as needed:

Dim bolVisible As Boolean
bolVisible = Not Me.subreportcontrol.HasData
Me.lbl1.Visible = bolVisible
Me.lbl2.Visible = bolVisible
. . .
 
Back
Top