COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: venkiatmaruthi on 16 Nov 2010 02:20:23 AM

Title: query giving no records
Post by: venkiatmaruthi on 16 Nov 2010 02:20:23 AM
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.