OraFAQ Forum: Reports & Discoverer » 0 insead of null in report output

Home » Developer & Programmer » Reports & Discoverer » 0 insead of null in report output

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

0 insead of null in report output [message #138980]

Mon, 26 September 2005 02:58

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

Report message to a moderator

Re: 0 insead of null in report output [message #139008 is a reply to message #138980]

Mon, 26 September 2005 05:13

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.

Report message to a moderator

Re: 0 insead of null in report output [message #139041 is a reply to message #138980]

Mon, 26 September 2005 06:39

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

Report message to a moderator

Re: 0 insead of null in report output [message #139046 is a reply to message #139041]

Mon, 26 September 2005 06:53

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.

Report message to a moderator

Re: 0 insead of null in report output [message #139065 is a reply to message #138980]

Mon, 26 September 2005 08:06

ravinderpuchala
Messages: 13
Registered: September 2005

Junior Member

i used that one still i am not getting
i am using matrix report

Report message to a moderator

Re: 0 insead of null in report output [message #287222 is a reply to message #138980]

Tue, 11 December 2007 08:21

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

Report message to a moderator

Re: 0 insead of null in report output [message #287268 is a reply to message #287222]

Tue, 11 December 2007 14:48

Littlefoot
Messages: 21813
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.

Report message to a moderator

Previous Topic:	new field
Next Topic:	Recompiling all reports after pll change?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 01:23:17 CDT 2024