OraFAQ Forum: Reports & Discoverer » zero to replace null value in Report

Home » Developer & Programmer » Reports & Discoverer » zero to replace null value in Report

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

zero to replace null value in Report [message #89751]

Fri, 16 July 2004 23:16

Satya
Messages: 36
Registered: January 2001

Member

hi

i want to replace zero in place of null fields.

i have used nvl(xyz,0) but still cannot generate zero on report

rather i could get zero in my sql promt

can anyone tell me where i am lacking behind

�

Thanks & Regards

satya

Report message to a moderator

Re: zero to replace null value in Report [message #89752 is a reply to message #89751]

Sat, 17 July 2004 01:37

Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta

Member

Hi Satya

In theproperty palette of the fiedl there isone Parameter called "Value if Null".
Just make it to - 0 and it will be taken care off.

Atul

Report message to a moderator

Re: zero to replace null value in Report [message #89753 is a reply to message #89752]

Sun, 18 July 2004 21:21

Satya
Messages: 36
Registered: January 2001

Member

hi atul,

I did as u said and could get 0 where the value is null in database,but how will i show 0 where data retrieved is nothing.

ex: i am retrieving no. of point in 2003 and 2002 for code xyz,here there are no records registered in 2002 under xyz n its values shows r blank on report n i cannot get 0 using as u said

what is the mistake that i might have done?

guide me

Thanks & Regards
satya

Report message to a moderator

Re: zero to replace null value in Report [message #89761 is a reply to message #89753]

Tue, 20 July 2004 00:54

Himanshu
Messages: 457
Registered: December 2001

Senior Member

Hi,
There is no mistake done by you.
You cannot show 0 if no matching data exists as the repeating frame on which your Feilds are placed will nver format if you do not have any data returned by your query.

What you may do in this case is to Put Dummy feilds over the original feilds with initial value as 0.
Add format triggers to these dummy feilds so that they are visible only if the original feild is null.

HTH
Regards
Himanshu

Report message to a moderator

Re: zero to replace null value in Report [message #89766 is a reply to message #89761]

Wed, 21 July 2004 18:24

Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta

Member

If you have a Matrix Report then .
If whatever point is your Value column in Matrix
the behin the matrix Frame put one dumy field with Value Zero and size (Width height ) same as your
point field.
SO wehenever your Point Field has no value then it zero will appear on its own.

If repeating frame normal report then
whatever Mr Himanshu idea is the best.

Regards
Atul p

Report message to a moderator

Previous Topic:	I Wish to unsubscribe to Orafaq com
Next Topic:	Image Logo appearing with black rectangle in report body

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 13:04:53 CDT 2024