Printing report with No data

  • Thread starter Thread starter RedHeadedMonster via AccessMonster.com
  • Start date Start date
R

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
 
RedHeadedMonster said:
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.
Click to expand...


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
 
Thanx I'll give it a try.
RHM

Marshall said:
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
Click to expand...
[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.
Click to expand...

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
Click to expand...
 
Back
Top