Running Total Issue

[marcyeager]

I'm using Version 11, and I have a report in which i'm using running totals to calcualte the total value of a field. My issue is that since the report for this group is multiple pages my total is being reset on the last page and not displaying the true total for the group.

Here are the formulas as I have them now.

Running Total
WhilePrintingRecords; NumberVar Amount := Amount + {@Fee Income}

Display Running Total (Located in Group Header)
WhilePrintingRecords; NumberVar Amount

Reset Running Total
WhilePrintingRecords; NumberVar Amount :=0;


Thanks in advance,
Marc

 

[lbass]

If you are placing the reset formula in a repeating group header, then it will reset on a new page. Change your reset formula to:

whileprintingrecords;
NumberVar Amount;
if not inrepeatedgroupheader then
Amount := 0;

-LB

 

[synapsevampire]

If you'd demonstrated what was in {@Fee Income} it wouold help.

You might be able to just use a formula in the group header of:

sum({@Fee Income},{table.group})

Depends on what's in {@Fee Income}...

-k