[Resolved] Showing sum in Crystal Reports group header

I have one formula which basically sums up another formula. This gives me the correct numbers. Then I have another formula which I attempt to display the sum and reset the counter. However I would like the sum to show in one of my group headers, but of course if I put the formula into the header, the total only correctly shows in the next group header, so all of the records are off by one. Is there a way in Crystal to make those appear in the header? The formulas are as follows:

This one computes the sum and is located in the group footer:
numbervar SumSales;
SumSales := SumSales + {@MonthlySales};

This one to display which works incorrectly when placed in group header:
whileprintingrecords;
global numbervar SumSales;
numbervar DispSales;

DispSales := SumSales;
SumSales := 0;
DispSales;

Crystal will handle everything for you. You may not need to create any extra formulas. Is @MonthlySales displayed on the report?

If yes, right click @MonthlySales and select Insert Summary. Set the required options and a new field will automatically be created in the Group Footer. Simply move this field to the Group Header.


If you want to create a formula yourself this is really all you need.

Sum ({@MonthlySales}, {Customers.CompanyName} )
-> Customers.CompanyName is the same field as your Group.

Then print this formula in the Group Header.