As you found the subreport prints nothing at all if the is no data in its
RecordSource.
If you still want its column headings to show even when there is no data to
print, the simplest option it to move the heading labels out of the
subreport, and onto the main report.
You can also do stuff like this in the Control Source of a text box on the
main report:
=IIf([Sub1].[Report].[HasData], Null, "Whatever you want to say.")
where Sub1 is the name of the subreport control.
If those ideas are not enough, you have to somehow get something into the
subreport's RecordSource. Changing the subreport's RecordSource to a UNION
query that contains at least one blank record would be one approach.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"bobh" <vu******@isp.c om> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. .
Hi All,
I have a report which has several sub-reports on it, Each sub-report
has its own record source and child/parent link.
Sometimes a sub-report may not have data for an entered policy nbr and
on the report thier is just an empty space where that sub-report would
be when that happens.
How do I get the sub-report to still display on the report when it has
no data????
I've tried putting code in the 'No Data' event of the sub-report but
that does not even get kicked-off when the underlining query has no
data.
thanks
bobh
