Report Footer Totaling in Crystal 9.0 1

[TheBig1980s]

In group footer #1 of a Crystal 9.0 report, I have the following formula:

if {#SumNetCost} < 5000 then {#SumNetCost} * .075 else (5000 * .075) + ({#SumNetCost} * .06)

It calculates correctly in the group footer, but not in the report footer.

When I research this issue on the net, I am finding that people out there are saying that it is not possible to get a report footer total for such a formula. This is because the formula is a running total formula and report footers do not allow for totaling running total formulas. Does anyone have any ideas?

 

[lbass]

Well, that's not true. You absolutely can use running totals in a report footer. However, I'm guessing that you want the sum of this formula, NOT running totals with no resets (what you would use for a report footer). You can use a variable to do this.

Create a formula to be placed in the same section as your formula, which we will call {@yourformula}:

whileprintingrecords;
numbervar x := x + {@yourformula};

Then in the report footer, use this formula:
whileprintingrecords;
numbervar x;

If your formula is a currency, then change "numbervar" to "currencyvar" in both formulas.

-LB

 

[TheBig1980s]

Thanks, lbass!!!

I think that that worked. I got a total. The client will review and let me know. But, in any case, I was able to get something concrete to him!

TheBig1980s