I have to create a Crystal Report which will print the below output for a date range.
Date : dd-mm-yyyy Description | Credit | Debit abc 2000 00 xyz 00 1000 Closing Balance: xxxx Opening Balance: xxxx Total Credit Till: Date xxxx Rs Total Debit Till: Date xxxx Rs
Query I have tried:
SELECT * FROM (SELECT BUSI_DATE AS busiDate, PARTICULARS AS "desc", AMOUNT, 'DR' AS transectionType FROM TRANSECTION_OUT WHERE BUSI_DATE BETWEEN @S_DATE AND @E_DATE UNION ALL SELECT BUSI_DATE AS busiDate, PARTICULARS AS particular, AMOUNT, 'CR' AS transectionType FROM TRANSECTION_IN WHERE BUSI_DATE BETWEEN @S_DATE AND @E_DATE) T ORDER BY T.busiDate
The problem is we have to print one day records in one page. I not much experienced with Crystal Reports - please help, how we can achieve this in Crystal Reports windows application?