In Crystal Report A/R Aging Report Detail section, I set the '@Paid' field formula as:
if {OJDT.TransType} = '13' then
{JDT1.BalFcDeb} - {JDT1.FCDebit}
else {jdt1.fccredit} - {jdt1.balfccred}
In Group Footer #1 (Group: OCRD: CardName), I set up '@Paid2' using formula :
{OCRD.BalanceFC} - sum({OJDT.FcTotal}) - {@Paid}
Group Footer #2 (Group: OCRD: CardName), '@TotalPaid' is the sum of the above two (@Paid + @Paid2) .
In Page Footer, I need the grand total of 'TotalPaid'. I used the following formula:
whileprintingrecords;
global numbervar GTotal:=Sum({@TotalPaid});
It gave me error message, 'the above cannot be summarized'. How do I fix the grand total field? Thanks.