Extra Page Header when no more records

[scott04]

I have a report that contains a report header, page header, page footer,
report footer, and within my report footer detail from my subreport. When I
pull for lets say two records, both records print on page one. Page two
gives me my monthly totals and year to date totals(from subreport) but at the
top of the page it gives me the same page header from page one. Page 3 gives
me the same page header from the previous pages but nothing under it. I
don't have a problem with the page header being on page two but do have a
problem with it creating an extra page on page 3. Can someone help me with a
work around? I do not want this page header to be moved to the report header
since there may be a time where the report will contain more than one page of
records but i also do not want it creating an extra page.

 

[Marshall Barton]

I have a report that contains a report header, page header, page footer,
report footer, and within my report footer detail from my subreport. When I
pull for lets say two records, both records print on page one. Page two
gives me my monthly totals and year to date totals(from subreport) but at the
top of the page it gives me the same page header from page one. Page 3 gives
me the same page header from the previous pages but nothing under it. I
don't have a problem with the page header being on page two but do have a
problem with it creating an extra page on page 3. Can someone help me with a
work around? I do not want this page header to be moved to the report header
since there may be a time where the report will contain more than one page of
records but i also do not want it creating an extra page.

A page header can not create an "extra page". It will only
appear if there is something in your report footer
(subreport?) that is actually printing on the third page.
One way to try to figure out where the blank stuff is
gomeing from is to set the report footer section anf the
subreport various section's BackColor to different colors.
Then it should be blindingly obvious where you have a
control that doesn't shrink or maybe just some unused space
at the bottom of a section.

 

[scott04]

Mashall,
I changed the color and it seems to be that my subreport is causing it to go
onto a 3rd page. My subreport is all of 2 inches in design view. I changed
my margins to under print setup to top .166, bottom 6, left .166, and right
..166 however it is still spilling over to an extra page. Any thoughts or
suggestions?

 

[scott04]

I finally got it to work. Thanks for your suggestion