Skip to Content
0
Former Member
Jan 12, 2012 at 05:19 PM

Crystal Report A/R Aging

96 Views

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.