I want to create balance site report where Payment and Receipts have two different column .
I have a table for voucher entry and I want to display payment in one column with voucher description and receipts in one column with specific voucher description in crystal report.
But details for payment are displayed in receipt section and in payment section details of receipts are displayed except amount. I have same datatable for both payment and receipt entries,
I want to display payment and receipt in same report with specific description
In report receipts section should not be filled with voucher number 'P-00001' it should only be displayed in payment section.
Similarly Voucher No- R-00003 should only be display in receipt section. Not in payment section.
In my table there is one field
payment ----in which two value are save.1-Receipts 2-Payment
so receipts value go to Receipt field and Payment value in Payment Field