Home » Developer & Programmer » Reports & Discoverer » Replce 0 with blanks in metrix reports
Replce 0 with blanks in metrix reports [message #230219] Wed, 11 April 2007 04:24 Go to next message
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 #230386 is a reply to message #230219] Wed, 11 April 2007 13:44 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
You can use NVL, like:
select nvl(comm,0) from emp
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 messageGo to next message
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
Littlefoot
Messages: 20901
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.
Previous Topic: Creating buttons in Reports
Next Topic: How can I create the dynamic column for the report
Goto Forum:
  


Current Time: Sun Dec 11 07:59:29 CST 2016

Total time taken to generate the page: 0.10235 seconds