Not seeing blank pages in a report

H

HighA

I have reports (5 of them) are in one report. Effectively they are
subreports. I would like to print
each subreport but have it so that they each start a new page and if one
doesn't have data in it, then not print at all and not leave a blank page in
its place. Each report is linked to a code which is referenced to an open
form. I have forced a page before the section in the individual reports but
they wont do that when they are acting as subreports.
Any help would be appreciated.

Cheers
John
 
D

Duane Hookom

How are you forcing page breaks now? Do you have page break controls between
the subreports? If so, you can make them invisible if the following
subreport has no data.

Me.pgbrkA.Visible = Me.subRptA.Report.HasData
 
H

HighA

I don't have page breaks as I was relying on the force page break in the
subreport header (which doesn't work). So I can add a page break between the
reports. Where do I then load the code? Into what control ?
Thanks
John
 
D

Duane Hookom

Load the code into the module of the report in the On Format event of the
section containing the subreports.
 
Top