asked on I have formulas that are not working to accum grand totals
I have this Formula for Yearly Totals
Shared NumberVar yearlyWages;
Shared NumberVar GrandWages;
GrandWages := GrandWages + yearlyWages;
yearlyWages;
It is placed in Group2 footer(there is nothing in Group1 footer)
In the report footer I have this formula for Grand Total
Global NumberVar GrandWages;
GrandWages
Yearly wages works fine.. it is being reset to 0 in Group header 2.
The GrandWages in the report footer is 0. It does not have the accumulated value.
What am I doing wrong?
Shared NumberVar yearlyWages;
Shared NumberVar GrandWages;
GrandWages := GrandWages + yearlyWages;
yearlyWages;
It is placed in Group2 footer(there is nothing in Group1 footer)
In the report footer I have this formula for Grand Total
Global NumberVar GrandWages;
GrandWages
Yearly wages works fine.. it is being reset to 0 in Group header 2.
The GrandWages in the report footer is 0. It does not have the accumulated value.
What am I doing wrong?
Crystal Reports
Last Comment
Mike McCracken
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks, I will try that.
ASKER
That worked for mostmof the totals in my grand total line except for 1 that is a little more complicated. I have this formula in Group2 Footer
Shared NumberVar yearlyWages;
Shared NumberVar MatchAllowed;
Shared NumberVar GrandAllowed;
Shared NumberVar Yearly401K;
Shared NumberVar Yearly401KM;
If (yearlyWages * .10) <= Yearly401K then
MatchAllowed := (yearlyWages * .10) * .10
else
MatchAllowed := Yearly401K * .10;
GrandAllowed := MatchAllowed;
MatchAllowed
and this one in Report Footer
Shared NumberVar GrandAllowed;
GrandAllowed
It is only getting the previous total.
MatchAllowed is not being cleared anywhere. It is working fine, just not accumulating in GrandAllowed.
Shared NumberVar yearlyWages;
Shared NumberVar MatchAllowed;
Shared NumberVar GrandAllowed;
Shared NumberVar Yearly401K;
Shared NumberVar Yearly401KM;
If (yearlyWages * .10) <= Yearly401K then
MatchAllowed := (yearlyWages * .10) * .10
else
MatchAllowed := Yearly401K * .10;
GrandAllowed := MatchAllowed;
MatchAllowed
and this one in Report Footer
Shared NumberVar GrandAllowed;
GrandAllowed
It is only getting the previous total.
MatchAllowed is not being cleared anywhere. It is working fine, just not accumulating in GrandAllowed.
ASKER
Never mind, I think I see it.
ASKER
How do I submit it. I selected your answer as best answer.
Just click the BEST SOLUTION box in the comment