Home » Developer & Programmer » Reports & Discoverer » Show Null when zero (6i windows 7)
Show Null when zero [message #625647] Sun, 12 October 2014 06:34 Go to next message
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.

http://i61.tinypic.com/28tx7qh.jpg
Re: Show Null when zero [message #625649 is a reply to message #625647] Sun, 12 October 2014 06:42 Go to previous messageGo to next message
Littlefoot
Messages: 21572
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 Go to previous messageGo to next message
Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan
Member
Thanks for your quick response.
Problem Solved
Re: Show Null when zero [message #625679 is a reply to message #625654] Mon, 13 October 2014 03:09 Go to previous message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Of you could use nullif, case or decode in the query.
Previous Topic: Arabic Character report 10g send directly to printer prints junk
Next Topic: Report Title
Goto Forum:
  


Current Time: Sat Jul 04 17:38:44 CDT 2020