Hi,
I have Summarized fields in my report.
I had to group by Customer 1st and then Invoice number.
Get the balances by invoice Number using the sum function by invoice number.
Use the sum values by invoice for calculating interest. To get the interest totals by customer used the following formulas.
Formula 1(placed on the Group Header1)
WhilePrintingRecords;
Global NumberVar Ordertotal;
Ordertotal := (0)
Formula 2 (Placed Group Fotter 2)
WhilePrintingRecords;
Global NumberVar Ordertotal;
Ordertotal := Ordertotal +
{@Interest }
Formula 3 ( Group Footer 1)
WhilePrintingRecords;
Global NumberVar Ordertotal;
I am able to get interest by the Customer. I want to get total interest for all customers as grand total.
Can anyone suggest a solution to this.
Thanking you,
Reddy
IP Logged
