Sub report

L

Laura Staveley

Hi,

I am having a problem with a Subreport in that if there is no dat
returned in the main report, the subreport does not run, even if ther
is data in the report. Probably something really simple I am doin
wrong. Can anyone please help?
Many thanks in advance,
Laur
 
A

Allen Browne

That is correct. If there is no data to present, you will get no output from
your subreport at all.

If you wanted to see a message when there was nothing in the subreport, you
could put a text box on your main report, with ControlSource something like
this:
=IIf([Sub1].[Report].[HasData], Null, "No subreport data.")

(Replace "Sub1" with the name of your subreport control.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.
"Laura Staveley" <[email protected]>
wrote in message
news:[email protected]...
 
Top