Home » Developer & Programmer » Reports & Discoverer » Matrix report format (Oracle Report Builder, 6.0.8.25.0, XP)
Matrix report format [message #446750] Wed, 10 March 2010 04:34 Go to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
I am trying to build a report in matrix format.
It displays the data properly.

I want to display 0 on blank places. how it is possible.
please have look on attached file.
Re: Matrix report format [message #446785 is a reply to message #446750] Wed, 10 March 2010 07:44 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell:

Unfortunately, there's no simple way of doing that. You can't use NVL in query (because, certain combinations of MGR and DEPTNO simply do not exist - they aren't null, they don't exist at all! You can't create a formula column which will return 0 for the same reason. You can't use "Value if NULL" field's property.

Therefore, you'll have to do it manually.

Go to Layout editor and create text item (using the Text tool) which will display the 0 digit:

/forum/fa/7549/0/

Send that text field to back:

/forum/fa/7550/0/

Move text field over the F_total field:

/forum/fa/7551/0/

Now you need to relocate it - it must be under the "Frequency R_G_deptno:R_G_mgr"; do that using the Layout menu, but this time "Move forward" (as many times as necessary - in our case, 3 times). The result must be as following:

/forum/fa/7552/0/

Final step: paint the original F_total field with white color:

/forum/fa/7553/0/

/forum/fa/7554/0/

When "total" contains a value, white F_total field will overwrite text field (B1). When there's no value, text field will be displayed on the screen.

Run the report; this is the result:

/forum/fa/7555/0/

I guess you'll want to remove red color as well as border line (but that's piece of cake).
Re: Matrix report format [message #446786 is a reply to message #446785] Wed, 10 March 2010 07:48 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Nice one Little foot.

sriram Smile
Re: Matrix report format [message #446788 is a reply to message #446750] Wed, 10 March 2010 07:55 Go to previous messageGo to next message
cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester
Senior Member
Impressive, and depressing that there isn't a simpler solution.
Re: Matrix report format [message #446796 is a reply to message #446785] Wed, 10 March 2010 08:33 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
Now you need to relocate it - it must be under the "Frequency R_G_deptno:R_G_mgr"; do that using the Layout menu, but this time "Move forward" (as many times as necessary - in our case, 3 times). The result must be as following:

thats true...Good one Little Foot.

Bt this is only for the PDF out put not for csv right ?
This is from reports 6i
/forum/fa/7556/0/

sriram Smile
  • Attachment: matrix.JPG
    (Size: 118.47KB, Downloaded 3115 times)

[Updated on: Wed, 10 March 2010 08:35]

Report message to a moderator

Re: Matrix report format [message #446883 is a reply to message #446785] Wed, 10 March 2010 22:01 Go to previous message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
Thanks Dear.

Quite amazing solution, but there should be some proper way, let oracle people know.

Anyway thanks a lot.

Regards.
Previous Topic: one query two groups second group multiple lines
Next Topic: Mouse scroll in Report 6i
Goto Forum:
  


Current Time: Tue Dec 03 20:39:53 CST 2024