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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

adding a value from the last row of data to the next row

Status
Not open for further replies.

TerriO

Technical User
Jan 9, 2002
84
US
I am using Crystal 8 and need to know how to add a row of data data to the next row of data from another field, example :




report report
column 1 column 2
A. 200 200 No calculation for row A
B 300 ? =Column 1 row B + Column2 row A
C 400 ? =Column1 row C + Column2 row B
D 500 ? =Column 1 row D + Column2 row C Etc.




Terri
 
Just use a Running Total field (Insert->Field Object->Right Click Running Totals and select New), add your columna and select type of summary Sum, with Evaluate For each record, and Reset Never, and place it in the details.

You can do this with code, but why bother?

-k
 
Thank you, sometimes theres a tendency to try to make things more complicated then they are, I have been working with RT's all day and the light bulb didnt go off? ;)

Terri
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top