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

Running Total field - Very Urgent please!!

Status
Not open for further replies.

jorg32

Programmer
Jul 10, 2003
57
0
0
BE
Hi,

I will start with the example because it is hard to explaine :

Report Header:
value of field =
100

In Detail lines I have several lines =
10 + 5 + 10

Total of this Group =
25

Total = 100 + 25 = 125

Next group has also several detail lines =
10+20+10

Total of this group =
40

Total = 125 + 40 = 165

And So On........
I think that this is not so difficult, but I think my mind is .......:-(

Thanks for helping me.
 
Without more specific technical information, I can only guess what you have nad need.

Crystal Version
Database and Connectivity
Sample input data
Any formulas, running totals affected
Expected output

Assuming that you created running totals, change your running total, (#total), with a never reset option
 
In the report header, place a formula {@init}:

whileprintingrecords;
numbervar sumx := 100;

In the group header, add this formula {@accum}:
whileprintingrecords;
numbervar sumx := sumx + sum({table.amount},{table.groupfield});

In the report footer, add this formula {@display}:
whileprintingrecords;
numbervar sumx;

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top