Home » Developer & Programmer » Reports & Discoverer » workaround to suppress null values in matrix report
workaround to suppress null values in matrix report [message #89936] Thu, 09 September 2004 04:32 Go to next message
Ramachandra Rao
Messages: 3
Registered: July 2004
Junior Member
In matrix report, How we can display zero value in the cells which are null.

Thanks in Advance

--Ramachandra Rao.

Report message to a moderator

Re: workaround to suppress null values in matrix report [message #89952 is a reply to message #89936] Tue, 14 September 2004 07:48 Go to previous messageGo to next message
SK
Messages: 26
Registered: March 2001
Junior Member
U have to create an text on the place where 0.00 needs to be displayed and give it a format trigger depending on the conditions.

Report message to a moderator

Re: workaround to suppress null values in matrix report [message #89956 is a reply to message #89936] Wed, 15 September 2004 05:29 Go to previous message
georg
Messages: 6
Registered: August 2004
Junior Member
make a new calculation and use the NVL()-function.
(for description see calculations-window)

georg

Report message to a moderator

Previous Topic: oracle reports 6i error
Next Topic: Finding the Date Difference in Oracle V 8.0.3
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 17:01:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.