Sub Total in Page Footer

[sern]

How can I display the subtotal on the page footer??
I have tried to drag it from the report footer but the system not allow me to do this.

 

[lbass]

Create the following three formulas:

Place this one {@resetpgtot} in the page header:

whileprintingrecords;
numbervar PageTotal := 0;

Place this one {@pgtotaldet} in the detail section:

whileprintingrecords;
numbervar PageTotal := PageTotal + {yourtable.amount};

Place this one {@displaypgtotal} in the page footer:

whileprintingrecords;
numbervar PageTotal;

-LB

 

[sern]

thanks lb.
i saw my problems. i forgot to place reset on the page header. thanks for your helps.

 

[sern]

how can i put the grand total in every page(page footer)?
i tried to use above formulas but failed. the report only show me the running total.

 

[lbass]

Instead of using an inserted grand total (which wouldn't work) for this purpose, create a formula {@grandtotal}:

sum({yourtable.amount})

Place this in the page footer. Please note that this formula assumes your grand total includes all records (no duplicates, no conditions). It will match the number you would get if you inserted a grand total into the report footer.

-LB