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
GROUP BY caste
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