I have a out put as you found in in Sheet Raw Data of the attached EXCEL file. I would like to have an out put results as I found in output sheet. I wanted to have it in single SQL. I tried using procedures with loops and also using connect by and rollup in EXCEL. I could not get the results. Can some one help me.
To give more details about the issue, Iam trying to print a General ledger of a group of accounts. I have completed a GL without grouping. for the given account the system will print Opening balances, for the month transaction and Closing balance.
But now the client want to take a GL for entire group. In my solution, the client will be able to print one report for every accounts available in a groups.