Home » Developer & Programmer » Reports & Discoverer » Problem in Oracle Reports
Problem in Oracle Reports [message #89676] Tue, 22 June 2004 03:48 Go to next message
Hemant Garg
Messages: 1
Registered: June 2004
Junior Member
Sir,

I am facing a problem in Oracle reports using Oracle Developer.

I am taking Count(*) group by other field, but report shows null values where count(*) = 0.

Please guide so that it shows 0 in place of 0.

thanks and regards,

hemant garg

Report message to a moderator

Re: Problem in Oracle Reports [message #89686 is a reply to message #89676] Thu, 24 June 2004 03:39 Go to previous message
Steve
Messages: 190
Registered: September 1999
Senior Member
hermant -

I believe this can be accomplished using the SQL command NVL(field_name, 0)

Regards,
Steve

Report message to a moderator

Previous Topic: Crystal_vs_OracleRpts
Next Topic: Discoverer reports on a browser.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 23:15:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.