extra blank page in report

  • Thread starter Thread starter Christopher Glaeser
  • Start date Start date
C

Christopher Glaeser

One of my reports has two pages. The report should fit on one page, and the
second page is blank. I've checked the Page Setup margins, oreintation,
etc, and I can't find what is causing the second blank page. There are two
sub-reports in the report, but they fit fine on the first page. The report
width is 6.5" with 1" margins. Any tips or suggestions on how to determine
what is causing the blank page?

Best,
Christopher
 
hi,
the usual cause of this is that the report is larger than
the page. Access is "seeing" something that makes it thing
it needs a second page.
Try adjusting the top and bottom margins or see if you
reduce the report length(top to Bottom) a tad.
 
Try adjusting the top and bottom margins or see if you
reduce the report length(top to Bottom) a tad.
Click to expand...

Thanks. I was able to squeeze the top and bottom margins a bit, and it now
fits on one page. However, it should have fit before. There is a
continuous sub-report that has no query matches and therefore is not
included in the report. In other words, the detail design page is 10.5"
long with the subreport, but the sub-report is empty and therefore the
actual printed part of the detail is only 8.5" long, so it should fit fine
on one page (if the sub-report is not empty, then the report is multiple
pages). The fields below the empty sub-report are moved up the appropriate
amount (e.g. there is no blank space allocated to the empy sub-report), but
it appears the non-printed sub-report is still affecting the overall page
size calcuation. Does that make sense? I'm guessing I need to set a
property of the sub-report somewhere to affect the page size calculation
when the sub-report is null.

Best,
Christopher
 
I shrunk the size of the views of the sub-reports in the report detail, and
then reduced the length of the report detail. Apparently, the size of the
view of a sub-report does not affect the size of the printed sub-report when
not emtpy. If the sub-reports are emtpy, the only space allocated is the
size of the view in the report detail. If the sub-reports are not empty,
then it is the size of the sub-report that is used, not the (much smaller)
size of the view of the sub-report in the report.

Best,
Christopher
 
Back
Top