can I create multi group report like: Group Above + Group Left etc. [message #674138] |
Mon, 07 January 2019 00:46 |
oralover2006
Messages: 144 Registered: January 2010 Location: India
|
Senior Member |
|
|
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 )
Bank Name can be appear before Column #1, it will be OK.
[b]Fund Name: ABC Fund In Flow[/b]
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
[b]Fund Name: ABC Fund Out Flow[/b]
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
[Updated on: Mon, 07 January 2019 00:47] Report message to a moderator
|
|
|
|
|