Printing report with No data

[RedHeadedMonster via AccessMonster.com]

I have a series of reports in an Access 2003 database. Currently I have them
set that if there is no data for a particualr report period the report comes
up with is headings and such but where the data is it says NONE. The problem
comes when I nest the report into the "Weekly Report" Then instead of showing
up as above it just simply does not show up. I assume it has something to do
with it being a subreport inside the Weekly Report, but how do I fix it so it
will show up with the NONE.

Thanx!
RHM

 

[Marshall Barton]

I have a series of reports in an Access 2003 database. Currently I have them
set that if there is no data for a particualr report period the report comes
up with is headings and such but where the data is it says NONE. The problem
comes when I nest the report into the "Weekly Report" Then instead of showing
up as above it just simply does not show up. I assume it has something to do
with it being a subreport inside the Weekly Report, but how do I fix it so it
will show up with the NONE.

Your analysis is correct, subreports display nothing when
they have no data.

The usual way to do what you want is to put a label control
(with caption None) on top of the subreport and make it
visible when the subreport is empty. The code in the
subreport's section's Format event would be like:

Me.label.Visible = Not Me.subreportcontrol.Report.HasData

 

[RedHeadedMonster via AccessMonster.com]

Thanx I'll give it a try.
RHM

I have a series of reports in an Access 2003 database. Currently I have them
set that if there is no data for a particualr report period the report comes

[quoted text clipped - 3 lines]

with it being a subreport inside the Weekly Report, but how do I fix it so it
will show up with the NONE.

Your analysis is correct, subreports display nothing when
they have no data.

The usual way to do what you want is to put a label control
(with caption None) on top of the subreport and make it
visible when the subreport is empty. The code in the
subreport's section's Format event would be like:

Me.label.Visible = Not Me.subreportcontrol.Report.HasData