How to replace Page Footer with Report Page Footer

  • Thread starter Thread starter yanto
  • Start date Start date
Y

yanto

Hi,
I am wondering, if I can put my Report Footer to replace Page Footer
position.
Is it possible to do that?
TIA
Yanto
 
No. You cannot easily move the report footer to the bottom of the page.

Firstly, the summary information that Access collects across the report is
not available if you use the page footer. There are workarounds, but the
data may be unreliable: depends on which pages were visited (if you rely on
events), and the timing of the compilation.

Secondly, the page footer appears on every page, not just the last one.

Thirdly, the Report Footer section can grow or shrink to fit the data,
whereas the page footer cannot.

One fudge is to programmatically determine when you are at the last record,
and look at the Top property of the report. You can then repeat the last
record over and over until you get far enough down the page that you are
happy to put the report footer there. By setting the report's runtime
properties MoveLayout to Yes but PrintSection to No, you do end up moving
down the page without displaying the last record repeatedly. But this is not
simple: just determining which is the last record is complicated by the
possibilty that the user can filter the report or change its OrderBy
property so that you cannot easily figure which one it is. To complicate
things further, Access does not maintain the report's properties (FilterOn
etc) correctly, so you cannot know whether the current value of its Filter
is real or an artifact. (This is fixed in Access 2007, but it's never been
possible in the previous 16 years to do this reliably.)
 
Thanks Allen for the fast response, in report properties, I can use
"not with rpt ftr" in Page Footer field so when the last page come
with the report footer, the page footer willl not be printed, then my
client want to place the GrandTotal (result of calculation in report
footer) in the page footer, so I thought there is combination of
properties setting that can move the rreport footer to replace the
page footer possition.
Alternatively I can use Group footer to keep GrandTotal but can the
group footer replace the pagefooter location?
The third solution sounds complicated to me, however thanks for your
oppinion, I appreciate it.
 
No: the Group Footer cannot be moved to the bottom of the page just by
setting properties either.
 
Back
Top