page sub_total

[rudwan]

i have report will print accounting trial balance , i made
text box at page footer to desplay
page sub_total , but it gives error
who i could do that ? in addition to transport this
sub_total to be desplayed at next page
page_header as previous balance

 

[Allen Browne]

To collect a total over just one page of a report, see:
Reports: Page Totals
at:
http://allenbrowne.com/ser-11.html

That approach (accumulating the value in the Print event of the detail
section) is not recommended for collecting or transferring totals across
different pages: if the user previews/prints only some pages of the report,
the events for the intervening pages may not execute, so the totals would be
wrong.

For that situation, set the Running Sum property of a text box instead.

 

[Andrew]

Remove your sum expression from the PAGE footer and put it in the REPORT footer, or in a "GROUP" footer if you have a "GROUP" footer. Calculating a total does not work in the PAGE footer section.