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 #88048] Thu, 24 January 2002 17:58 Go to next message
Ashwin John
Messages: 3
Registered: January 2002
Junior Member
I want display 0 in cells with no values in a matrix report.
For eg consider the matrix below. The row value is 'party'. The column value is 'Month' and the cell value is quantity sold.

Party--------Apr-----May
-----------------------------------
xyz-----------5
abc-------------------7

Party xyz has sold a quantity of 5 in April, but has sold nothing in May. Similarly party abc has sold quantity 7 in May but nothing in April. How do i display 0 in cells with no values?
Re: Displaying 0 in cells with no values in a matrix report [message #88052 is a reply to message #88048] Mon, 28 January 2002 20:40 Go to previous message
Fadwa
Messages: 4
Registered: January 2002
Junior Member
That is done by using text. You can have the full description in this site(in the last section): boilerplatehttp://technet.oracle.com/doc/reports25/bror2/ch5a.htm#one-query%20steps
hope this will help you in solving your problem
Previous Topic: Re: Choosing a report software for ORACLE/JAVA
Next Topic: Re: printing reports usings forms 6i on web
Goto Forum:
  


Current Time: Tue Dec 17 21:35:44 CST 2024