Link to home
Create AccountLog in
Avatar of Metalteck
MetalteckFlag for United States of America

asked on

Manual Running Total is not Resetting

I have a crystal report I wrote in Crystal 2008 off sql 2008.

For some reason, whenever a report group does not have a DPE value, it is picking up the DPE value from the previous record. Can someone help me solve this.

Thanks

In this report I have 4 groups;
Group 1 = Report Group
Group 2 = Grouping Summary Level 3
Group 3 =  Division Level
Group 4 = Group Sort

I have the reset formula in GH2.
Reset formula:
whileprintingrecords;
numbervar DPE;
""

I have the Summation being done in GH3
Summation Formula:
WhilePrintingRecords;
NumberVar DPE;

if {@Grouping Summary Level 3} = 'PAYROLL' THEN
       DPE := Sum ({@Month 3}, {@Grouping Summary Level 3})

I have the Display being shown in GF2
Display Formula:
whileprintingrecords;
numbervar DPE;  
DPE
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer