Need Report Totals to print on all pages. 3

[ufiut]

I have a calculation on the report footer that I want to appear on all report pages not just the last page. I tried putting the calculation on the page footer, but this does not work.

What can I do to force the report total to appear on all pages?

Thank you.

Isabel

 

[Steve101]

Isabel,

Try the following:

(a) LEAVE the existing calculation on the report footer. Take note of the TextBox name associated with the control containing the calculation. I'll assume its called txtReportTotal.

(b) Add a new control to the PageFooter. I'll call it txtReportPageTotal for the purposes of this post.

(c) set the controlSource property of your txtReportPageTotal to:
=txtReportPageTotal

Make sure that you include the equal sign on the left.

That should hopefully do the trick, Cheers,

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au

 

[Steve101]

Oops! I messed up in step (c) above. Correction is as follows:

(c) set the controlSource property of your txtReportPageTotal to:
=txtReportTotal

While I'm here: You might also wish to make the control on the ReportFooter section not visible by the appropriate visible property setting; You may wish to make the entire section not visible (ie. via the property associated with the Section).



Cheers,

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au

 

[ufiut]

This was exactly what I was looking for. Thank you very much. I really appreciate your help.

Isabel