I have created a database contains three tables.
Table Names :
deposits : "dpid","date","custname","description","chqno","duedate","accname","amount"
bank charges : "bankid","date","accountname","description","amount"
Opening Balance : "opbid","date","accountname","amount"
I need to create a crystal report using above three tables.If i selected these three table it shows all the datas correctly like below,
"date","custname","chqno","duedate","amount","bankid","date","amount","opbid","accountname","amoun"
i need opening balance amount in a column and the other two amounts in a column in a date order. And need to substract deopsit amount and bank cahrges amount from opening balance amount. Can anyone help me to find a good answer for this