Home » Developer & Programmer » Reports & Discoverer » Return 0 if no record found????
Return 0 if no record found???? [message #146678] Sat, 12 November 2005 02:51 Go to next message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member
Dear Sir,

I want to show 0 if the query does not return an value. How to do it. I have four different query in my query editor out of which one is not returning value but others are returning value. I want to show that value which is not returning value to zero.

Please help it is urgent

Samit Gandhi

Report message to a moderator

Re: Return 0 if no record found???? [message #146706 is a reply to message #146678] Sat, 12 November 2005 15:13 Go to previous message
sachinjainonweb
Messages: 24
Registered: October 2005
Junior Member
hi
create one report level count summary column which counts the row in your query . Refer to this summary column in your report.


Luck Always

Report message to a moderator

Previous Topic: Oracle Reports 6i
Next Topic: Question on Changing Fields at the EUL Level
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 01 02:27:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.