Subreports with no data

  • Thread starter Thread starter DK
  • Start date Start date
D

DK

If a subreport has no data I want the subreport's header
to be displayed anyway. For a stand alone report this is
handled by adding the appropriate code to the report's
NoData event. I make a lable visible that says no data is
available. This does not work when the report becomes a
subreport. Any suggestions? Thanks.
 
Try a text box with Control Source of:
=IIf([MySub].HasData, Null, "Nuffin 2 show.")
 
This is exactly what I'm trying to accomplish, but I'm not sure where to put
this command. I tried this on the Event On No Data. I pasted the command on
that line and changed [MySub] to my subreport name. My results didn't
change.

What am I doing wrong.
Thanks for your help.
G. Wolfe

Allen Browne said:
Darn. Try:
=IIf([MySub].[Report].[HasData], Null, "Nuffin 2 show.")
Click to expand...
 
Back
Top