OraFAQ Forum: Reports & Discoverer » Show Null when zero

Home » Developer & Programmer » Reports & Discoverer » Show Null when zero (6i windows 7)

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

Show Null when zero [message #625647]

Sun, 12 October 2014 06:34

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

I have made a report that show my current stock.
I want to do when my stock goes to ZERO (0) then Report does not show 0 but show as null.

screen shot is attached, I Want to show every ZERO (0) as null or blank.

Report message to a moderator

Re: Show Null when zero [message #625649 is a reply to message #625647]

Sun, 12 October 2014 06:42

Littlefoot
Messages: 21765
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Create Format trigger on the CONS field:

return :cons <> 0;

[Updated on: Sun, 12 October 2014 06:42]

Report message to a moderator

Re: Show Null when zero [message #625654 is a reply to message #625649]

Sun, 12 October 2014 12:44

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

Thanks for your quick response.
Problem Solved

Report message to a moderator

Re: Show Null when zero [message #625679 is a reply to message #625654]

Mon, 13 October 2014 03:09

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

Of you could use nullif, case or decode in the query.

Report message to a moderator

Previous Topic:	Arabic Character report 10g send directly to printer prints junk
Next Topic:	Report Title

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 03 03:06:07 CDT 2023