Home » Developer & Programmer » Reports & Discoverer » can I create multi group report like: Group Above + Group Left etc. (Win 8.1, DB 12c,, Reports 12c)
can I create multi group report like: Group Above + Group Left etc. [message #674138] Mon, 07 January 2019 00:46 Go to next message
oralover2006
Messages: 125
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

Re: can I create multi group report like: Group Above + Group Left etc. [message #674143 is a reply to message #674138] Mon, 07 January 2019 04:41 Go to previous messageGo to next message
oralover2006
Messages: 125
Registered: January 2010
Location: India
Senior Member
OK, I built this report using multiple times assign groups, 3 in this case 1) Fund 2) I/O 3) Bank

for those who don't know:
first assign Fund column to group Click Next then Back and again assign I/O column as 2nd group and same for Bank.

thanks to all.
love you Smile
Re: can I create multi group report like: Group Above + Group Left etc. [message #674211 is a reply to message #674143] Thu, 10 January 2019 14:39 Go to previous message
Littlefoot
Messages: 21455
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"Group above" and "Group left" sound like a matrix layout to me. It is offered in the Wizard. Did you try it? (Yes, I know, you said you solved the problem, but going back and forth doesn't look like a normal way to do that).
Previous Topic: rep-69: An internal error occurred
Next Topic: REP-51002: Bind to Reports Server bb failed.
Goto Forum:
  


Current Time: Wed Jan 16 12:42:34 CST 2019