Calculating SUMs of page records 1

[Engiman]

In page footers of a tabular report there must be printed sums of the pages records. How it can be done in Crystal Report v. 8.x ? Thanks

 

[Hattusas]

Insert summary field into group footer. Salih Sipahi
Software Engineer.
City of Istanbul Turkey
openyourmind77@yahoo.com

 

[Engiman]

Well, that didn't work. There's no groups in the report.

 

[dgillz]

Do you want a page total at the bottom of each page?

If so use variables and the 3 formula technique, see the FAQ section for a very good FAQ regarding this.

Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[Engiman]

Thank you, dgillz

Your suggestion was very helpfull. I solved the problem like this

Step 1: Create a running total {#rtt_total} for the required report field

Step 2: Create a formula field {@page_total}

'page_total formula field
global page_total as number
local rtt_value as number

call EvaluateAfter({#rtt_total})
rtt_value={#rtt_total}
formula=rtt_value-page_total
page_total=rtt_value

Step 3: Place the formula field in the page footer section