OraFAQ Forum: Reports & Discoverer » Displaying 0 in cells with no values in a matrix report

Home » Developer & Programmer » Reports & Discoverer » Displaying 0 in cells with no values in a matrix report

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

Displaying 0 in cells with no values in a matrix report [message #88044]

Wed, 23 January 2002 23:05

Ashwin John
Messages: 3
Registered: January 2002

Junior Member

How do u display 0's in cells with no values in a matrix report

Report message to a moderator

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

sokeh
Messages: 77
Registered: August 2000

Member

nvl?
eg select nvl(sal,0) from emp;

Report message to a moderator

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

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)

Attachment: matrix_fopl.JPG
(Size: 34.44KB, Downloaded 1986 times)

Report message to a moderator

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

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

Senior Member
Account Moderator

Have a look at an example I created years ago.

Report message to a moderator

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

randriana
Messages: 18
Registered: September 2010

Junior Member

thanks a lot my friends it's help me more

Report message to a moderator

Previous Topic:	Getting Sum of Student gender wise...
Next Topic:	Generate reports 6i to Thai output

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 06 19:12:28 CST 2025