query giving no records

[venkiatmaruthi]

Hi,
I have a query in Cognos report. the query returns the Plan_Date between the given start & end dates.

If the plan_date exists between those start & end dates then the query executing successfully and the report showing the result.
If the plan_date does not exist between those start & end dates then also the query executing successfully but no records coming in SQL. i.e.  No data is coming in Cognos. Since there is no data the reprot is giving blank.

Now I want to give 0 or 1 if the there is no data. How I can handle this?




Thanks.
Venkat.