Home » Developer & Programmer » Reports & Discoverer » 0 insead of null in report output
0 insead of null in report output [message #138980] Mon, 26 September 2005 02:58 Go to next message
ravinderpuchala
Messages: 13
Registered: September 2005
Junior Member
hi


i am betting blank space in my report. i want 0 value in that field
i tried with nvl and report property value if null but i am not getting
give me a advice

thanx
ravi
Re: 0 insead of null in report output [message #139008 is a reply to message #138980] Mon, 26 September 2005 05:13 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

how you'r using NVL in the report query?
This query returns the o for commission in the report output instead of NULL values.
SELECT empno, ename, job, sal, NVL(comm,0) comm, deptno
FROM emp


Regards.
Re: 0 insead of null in report output [message #139041 is a reply to message #138980] Mon, 26 September 2005 06:39 Go to previous messageGo to next message
ravinderpuchala
Messages: 13
Registered: September 2005
Junior Member
i am using matrix report

in that some of row column combination doesn't have the value

so i am getting blank space


instead of that i want 0 value in that cell

ravi
Re: 0 insead of null in report output [message #139046 is a reply to message #139041] Mon, 26 September 2005 06:53 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

Open the property pallete of that cell and change the Value if Null property to 0.

Regards.
Re: 0 insead of null in report output [message #139065 is a reply to message #138980] Mon, 26 September 2005 08:06 Go to previous messageGo to next message
ravinderpuchala
Messages: 13
Registered: September 2005
Junior Member
i used that one still i am not getting
i am using matrix report
Re: 0 insead of null in report output [message #287222 is a reply to message #138980] Tue, 11 December 2007 08:21 Go to previous messageGo to next message
pakistani
Messages: 1
Registered: December 2007
Location: uae
Junior Member

Please use this link, ur problem will be resolved
http://download-uk.oracle.com/docs/cd/B14099_15/bi.1012/b13895/orbr_matrix.htm
Re: 0 insead of null in report output [message #287268 is a reply to message #287222] Tue, 11 December 2007 14:48 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you for the contribution, Pakistani. As it is your maiden post, perhaps you'd be interested in reading the OraFAQ Forum Guide. In the meantime, a suggestion - check date of the previous post. In this topic, it was written more than 2 years ago and it is doubtful whether these people still need help or not. There are more recent topics which need to be answered, so - maybe you should focus on them instead.
Previous Topic: new field
Next Topic: Recompiling all reports after pll change?
Goto Forum:
  


Current Time: Wed Dec 07 07:12:26 CST 2016

Total time taken to generate the page: 0.19549 seconds