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: 127
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: 20897
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:

./fa/7549/0/

Send that text field to back:

./fa/7550/0/

Move text field over the F_total field:

./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:

./fa/7552/0/

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

./fa/7553/0/

./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:

./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: 2454
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: 12409
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: 2454
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
./fa/7556/0/

sriram Smile
  • Attachment: matrix.JPG
    (Size: 118.47KB, Downloaded 1309 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: 127
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: Wed Dec 07 03:21:16 CST 2016

Total time taken to generate the page: 1.04391 seconds