How to display page wise running totals in crystal 8.5 2

[gubhare]

Hi,

I want to display page wise running totals i.e. the running total should be reset after each page. How can I achieve this as I can not find any way of doing this.

I am stuck with this problem can somebody pls help

Thanks in advance


Cheers
Ganesh

 

[Madawc]

Running totals do not take notice of page changes. You'll need to use shared variables, see

http://www.tek-tips.com/viewthread.cfm?SQID=666482&SPID=767&page=1

Madawc Williams (East Anglia)

 

[GJParker]

One way to do this would be to create manual running totals using formulas i.e.

Place this in the Page Header section and suppress it
//@Reset
WhilePrintingRecords;
Shared NumberVar RTotal :=0;

Place this in the whichever section contains the field you want to total
//@RunningTotal
WhilePrintingRecords;
Shared NumberVar RTotal := RTotal + {Field to total};
RTotal

Place this in the page footer section
//@Display
WhilePrintingRecords;
Shared NumberVar RTotal;
RTotal

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[gubhare]

Thank you very much guys for u r help. I have done they way you have suggested and it worked.



Cheers
Ganesh