displaying a column in report which returns null value

From: <dtrusha_at_gmail.com>
Date: 8 Mar 2007 22:02:27 -0800
Message-ID: <1173420147.016604.284770_at_p10g2000cwp.googlegroups.com>



Hi
[Quoted] I have a simple report with two column. The query is as below. SELECT decode(caste,1,'SC/ST',2,'General','3','PWD') fcastepi, nvl(count(*),0) fcapi

   FROM applicationformdtl
WHERE year = :p_year

      AND selected = 1
     AND PROGCD = 'PRM'

 GROUP BY caste

This query returns values for SC/ST and General as there is no matching data for the PWD. But I want to display PWD with value 0 in the report. How to do this? Can anyone help me in this matter at the earliest?

The required output is
SC/ST 100
General 300
PWD 0 Regards
Trusha Received on Fri Mar 09 2007 - 07:02:27 CET

Original text of this message