Home » Developer & Programmer » Reports & Discoverer » Displaying 0 in cells with no values in a matrix report
Displaying 0 in cells with no values in a matrix report [message #88044] Wed, 23 January 2002 23:05 Go to next message
Ashwin John
Messages: 3
Registered: January 2002
Junior Member
How do u display 0's in cells with no values in a matrix report
Re: Displaying 0 in cells with no values in a matrix report [message #88046 is a reply to message #88044] Thu, 24 January 2002 07:11 Go to previous messageGo to next message
sokeh
Messages: 77
Registered: August 2000
Member
nvl?
eg select nvl(sal,0) from emp;
Re: Displaying 0 in cells with no values in a matrix report [message #602226 is a reply to message #88046] Mon, 02 December 2013 01:15 Go to previous messageGo to next message
randriana
Messages: 18
Registered: September 2010
Junior Member
this url http://docs.oracle.com/cd/E12839_01/bi.1111/b32122/orbr_matrix006.htm#i1012231 may help every one
but mine had problem summaries and the text juxtaposed: displayed together even if summaries is not null, then i need help of you if some of you will find the solution. (attached)
Re: Displaying 0 in cells with no values in a matrix report [message #602309 is a reply to message #602226] Tue, 03 December 2013 00:17 Go to previous messageGo to next message
Littlefoot
Messages: 21509
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Have a look at an example I created years ago.
icon14.gif  Re: Displaying 0 in cells with no values in a matrix report [message #602359 is a reply to message #602309] Tue, 03 December 2013 06:32 Go to previous message
randriana
Messages: 18
Registered: September 2010
Junior Member
thanks a lot my friends it's help me more
Previous Topic: Getting Sum of Student gender wise...
Next Topic: Generate reports 6i to Thai output
Goto Forum:
  


Current Time: Fri Nov 15 14:29:25 CST 2019