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!
./fa/5803/0/
  • Attachment: Matrix.JPG
    (Size: 109.88KB, Downloaded 855 times)
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: 25046
Registered: January 2009
Location: SoCal
Senior Member
OK,
pretty post.
what is the question.
What do you desire as a response?
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: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you, please, post screenshot of the Data Model Editor?
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:

./fa/5804/0/
  • Attachment: DataModel.JPG
    (Size: 95.67KB, Downloaded 762 times)
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
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: 20901
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").
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?
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:
  


Current Time: Fri Dec 09 05:56:45 CST 2016

Total time taken to generate the page: 0.11629 seconds