Hi All
am creating a Deposit report.
currently I have done it in this layout.
Deposit Account I Deposit Account Name I Amount
12020401 Barclays Bank 1000
12020402 KCB Bank 1000
12020403 Guardian Bank 1000
12020404 Equity Bank 1000
i wanted to convert it to the following layout.
Deposit Source I Account Name I Barclays Bank I KCB Bank I Guardian Bank I Equity Bank
12020301 Chq Control A/c Amount Amount Amount Amount
12020201 Cash Control A/c Amount Amount Amount Amount
12020302 Chq Control A/c Amount Amount Amount Amount
12020202 Cash Control A/c Amount Amount Amount Amount
12020303 Chq Control A/c Amount Amount Amount Amount
12020203 Cash Control A/c Amount Amount Amount Amount
12020304 Chq Control A/c Amount Amount Amount Amount
12020204 Cash Control A/c Amount Amount Amount Amount
__________________________________________________________________________________________________
Total Total Deposited Total Deposited Total Deposited Total Deposited
Source is the Deposit Source- 1202030* are Control Accounts for Cheque Deposits
1202020* are Control Accounts for Cash Deposits
Anybody who can help to go about this.