Home » Developer & Programmer » Reports & Discoverer » How to I create a nested matrix (grouped column) report in oracle report builder?
How to I create a nested matrix (grouped column) report in oracle report builder? [message #389033] Fri, 27 February 2009 01:37 Go to next message
rhedgirl
Messages: 4
Registered: February 2009
Junior Member
Hi,

Im having some (well huge!) problem regarding matrix report. My matrix is basically a nested one, but instead of having multiple levels in the row part, i have to have multiple levels in column part. (Please see attached/below file for clearer image of what i want to have).

By the way I'm using Oracle Report Builder (10g). I followed the instructions in chapter 26 of Oracle® Reports Building Reports
10g Release 2 (10.1.2) document.


Any suggestions will be very welcome. Thanks! /forum/fa/5803/0/
  • Attachment: Matrix.JPG
    (Size: 109.88KB, Downloaded 2453 times)

Report message to a moderator

Re: How to I create a nested matrix (grouped column) report in oracle report builder? [message #389038 is a reply to message #389033] Fri, 27 February 2009 01:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
OK,
pretty post.
what is the question.
What do you desire as a response?

Report message to a moderator

Re: How to I create a nested matrix (grouped column) report in oracle report builder? [message #389042 is a reply to message #389033] Fri, 27 February 2009 01:54 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you, please, post screenshot of the Data Model Editor?

Report message to a moderator

Re: How do I create a nested matrix (grouped column) report in oracle report builder? [message #389075 is a reply to message #389042] Fri, 27 February 2009 03:34 Go to previous messageGo to next message
rhedgirl
Messages: 4
Registered: February 2009
Junior Member
Littlefoot wrote on Fri, 27 February 2009 01:54
Could you, please, post screenshot of the Data Model Editor?


Basically this is what my data model looked like:

/forum/fa/5804/0/
  • Attachment: DataModel.JPG
    (Size: 95.67KB, Downloaded 2244 times)

Report message to a moderator

Re: How do I create a nested matrix (grouped column) report in oracle report builder? [message #389078 is a reply to message #389038] Fri, 27 February 2009 03:44 Go to previous messageGo to next message
rhedgirl
Messages: 4
Registered: February 2009
Junior Member
BlackSwan wrote on Fri, 27 February 2009 01:44
OK,
pretty post.
what is the question.
What do you desire as a response?



I just want to know how do I design the layout (or is there something wrong with my data model?) so that the report will look like the 1st figure i posted.

Currently, my report looked like the second one.. i have perfectly grouped the columns but having trouble with the cell value.. it's not printing horizontally but downwards.. i have tried to play with the print direction property of the cell's repeating frame but it didn't solve my problem Sad

Report message to a moderator

Re: How do I create a nested matrix (grouped column) report in oracle report builder? [message #389242 is a reply to message #389078] Fri, 27 February 2009 14:40 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Huh, that's what I was going to suggest - adjust repeating frame's "Print direction" property to "Across".

What is repeating frame's elasticity property set to? Is any of them "Fixed" or "Contract"? If so, try to set it to "Expand" (or "Variable").

Report message to a moderator

Re: How do I create a nested matrix (grouped column) report in oracle report builder? [message #389395 is a reply to message #389242] Sun, 01 March 2009 19:26 Go to previous message
rhedgirl
Messages: 4
Registered: February 2009
Junior Member
Littlefoot wrote on Fri, 27 February 2009 14:40
Huh, that's what I was going to suggest - adjust repeating frame's "Print direction" property to "Across".

What is repeating frame's elasticity property set to? Is any of them "Fixed" or "Contract"? If so, try to set it to "Expand" (or "Variable").


I did that already but also no success. I tried to make a simple matrix - no column grouping - and it worked successfully. So I was thinking, is it really possible to group/nest the columns in a matrix? or that would only be applicable in rows, as discussed in the document?

Report message to a moderator

Previous Topic: error rep-1401 in formula column of report builder 2.1
Next Topic: How to use DATA_PARAMETER in 10g forms
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 02:41:47 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.