Click here to Skip to main content
15,881,173 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am new to crystal reports and I am using OLEDB Connection with MS Access 2007 Database
I am trying to display the two different sections of Payment Vouchers such as Receipt Vouchers and Payment Vouchers. I want to display the receipt vouchers and at the end of Receipt Vouchers display the Total Amount Of Receipt Vouchers and then i want to display the payment vouchers and at the end of Payment Vouchers display the Total Amount Of Payment Vouchers.
My requirement:
I pass the two dates start date and end date.
Opening Balance should be displayed of start date and closing balance should be displayed of end date.
Display all the vouchers from start date to end date
At the display the opening balance of start date and the bottom display the closing balance of end date.
Display all receipt vouchers from start date to end date and at last display the total receipt vouchers amount
Display all the payment vouchers from start date to end date and at last display the total payment vouchers amount
My Table are as follows
I have tables such as payment_vouchers, balance_details, voucher_types, branch_master. The payment_vouchers table contains the both receipt and payment vouchers along with voucher date, voucher number voucher_type_id, branch_code and voucher amount, balance_details contains the date wise opening and closing account balance

Thanks To you all
Posted
Updated 9-Oct-14 1:44am
v2

1 solution

I just used grouping method of a Crystal Report
I create a group based on voucher type
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900