Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating SUMs of page records 1

Status
Not open for further replies.

Engiman

Programmer
Mar 5, 2002
5
RU
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
 
Insert summary field into group footer. Salih Sipahi
Software Engineer.
City of Istanbul Turkey
openyourmind77@yahoo.com
 
Well, that didn't work. There's no groups in the report.
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top