Skip to Content
0
Former Member
Dec 26, 2012 at 11:41 AM

Dynamic grouping in crystal report ?

147 Views

Hi Friends ,

I am using 2 Groups in crystal report 1. Document No and 2. DR_CR .

and I am Created a Formula AMOUNT which is placed in Document no footer .

Please check my image file for better understanding , I need to sub the amount document no group wise . (i,e) sum(Debit amount) - sum(credit amount).

whileprintingrecords;

if ({RPD.DR_CR}) = 'C' then

(

cr:= sum({RPD.SUBLEDGER_LOCAL_AMOUNT},{RPD.DOCUMENT_NO})

)

else if

{RPD.DR_CR} = 'D' then

(

dr:=sum({RPD.SUBLEDGER_LOCAL_AMOUNT},{RPD.DOCUMENT_NO})

) ;

Attachments

DC.jpg (75.5 kB)