Cashbook report in Crystal Reports

Asked by At

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?

0 Answers