Metalteck
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
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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.