hi all,
working on Oracle Reports 12c with DB 12c
I have a requirement to create a report like below: ( note: I have created Group Above but failed to achieve this below requirement )
Fund Name: ABC Fund In Flow
Column #1 Column #2 Bank Name Amount
--------- --------- ------------- --------
Value #1 Value #2 Bank's Name A 1.00
Value #1 Value #2 2.00
Value #1 Value #2 3.00
Bank A Total: 6.00
Value #1 Value #2 Bank's Name B 1.00
Value #1 Value #2 2.00
Value #1 Value #2 3.00
Bank B Total: 6.00
Fund In Flow Total: 12.00
Fund Name: ABC Fund Out Flow
Column #1 Column #2 Bank Name Amount
--------- --------- ------------- --------
Value #1 Value #2 Bank's Name A 1.00
Value #1 Value #2 2.00
Value #1 Value #2 3.00
Bank A Total: 6.00
Value #1 Value #2 Bank's Name B 1.00
Value #1 Value #2 2.00
Value #1 Value #2 3.00
Bank B Total: 6.00
Fund Out Flow Total: 12.00
Fund ABC Total: 24.00
and then another Fund ... etc.
it seems Group Above and Group Left ( if I am not wrong ) so, how i can achieve this? please guide me.
regards