Multiple document types in crystal report
i try to fetch multiple doc types in crystal report.. If doc type is CN then amount in - and if amount doc type is DN then it must be + ... . i want like this
Code:
crystal report
no. doctype docno docdate customer exempteddate S.Tax Rate S.t Amount
1 CI 12 01-01-2016 ABC 150 20% 15200*
1 CN 12 01-01-2016 abc -32 20% 1234*
this is what i tried
crystal report
Code:
no. doctype docno docdate customer exempteddate S.Tax Rate S.t Amount
1 CI 12 01-01-2016 ABC 150 20% 15200*
whatever the amount is i write rough amount
query ...i paste specific line
Code:
and acdochdr.doctype='CN', 'DN' ,'CI'
any solution?