Add totals in the report page footer (1 Viewer)

[Teggun]

Hello guys, I'm having a problem since long time where I can not add totals in the page footer of a report, it returns me an error.

Totals work fine in report footer and specific group footer but not in the page...
The reason I need this is to have the sum of an amout placed in the very bottom of the page, and I could only find the way of doing so by using the page footer. If using the report footer it is placed right after the end of the data not in the bottom of the page.

If there a way to keep the report group in the very bottom of the page, not right after the data ends?
Or a way to add the sum in the page footer and not getting an error?

Thanks in advance for your time.

 

[arnelgp]

just add it in the Report Footer, adjust its height to 0 and make it's Visible property to No.
then adjust the Report Footer to (0 height).

next add another Unbound textbox to the Page Footer with ControlSource:

=[theTotalTextboxNameOnReportFooter]

 

[Pat Hartman]

You can't automatically create page totals in a report the way you can create report and group totals. You need custom code in the report's detail section to calculate the total shown on any given page. And then code in the Page Footer to display the total and clear the accumulator so it is ready for the next page.