Replce 0 with blanks in metrix reports [message #230219] |
Wed, 11 April 2007 04:24 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
archit_gaj
Messages: 9 Registered: February 2007 Location: Navi Mumbai
|
Junior Member |
|
|
how can i display 0 in metrix cell products.
my output is like
------------------
Name| Item
------------------------
- | X | Y | Z
A | 11 | 20 | 30
B | 14 | | 12
C | 12 | |
D | | 14 | 15
My Out put will be
------------------
Name| Item
-------------------------
- | X | Y | Z
A | 11 | 20 | 30
B | 14 | 0 | 12
C | 12 | 0 | 0
D | 0 | 14 | 15
i want to display 0 in blank spaces.
[Updated on: Wed, 11 April 2007 04:27] Report message to a moderator
|
|
|
|
Re: Replce 0 with blanks in metrix reports [message #230476 is a reply to message #230386] |
Thu, 12 April 2007 01:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
archit_gaj
Messages: 9 Registered: February 2007 Location: Navi Mumbai
|
Junior Member |
|
|
i have made nvl changes in my reports but still it's not
working.
It will display blanks.
because of my query will get amount as per name(row) and item (column)only not zero if it amoun is not there than it will not be display as null.
|
|
|
Re: Replce 0 with blanks in metrix reports [message #230765 is a reply to message #230476] |
Thu, 12 April 2007 14:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
archit_gaj | because of my query will get amount as per name(row) and item (column)only not zero if it amoun is not there than it will not be display as null.
|
Excuse me? How would you translate this sentence (sentence?) to English? Should there be a capital letter there? Full stop? Question mark? Comma? I must admit: I read this line over and over again, and I have no idea what you are talking about.
But I understood this:Quote: | It will display blanks.
|
I hope you are aware of the fact that blanks <> NULL. So what are you, actually, doing here? Displaying NULLs or blanks (blanks = string!)? NVL function won't do much good on blanks.
To help me (us) better understand your problem, it would be fine if you could create a sample test case (including CREATE TABLE and INSERT INTO statements) and, of course, query you used to retrieve the result.
|
|
|