| Matrix report format [message #446750] |
Wed, 10 March 2010 04:34  |
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  |
 |
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:
Send that text field to back:
Move text field over the F_total field:
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:
Final step: paint the original F_total field with white color:
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:
I guess you'll want to remove red color as well as border line (but that's piece of cake).
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
