COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: lostmytoy on 09 Dec 2009 09:00:16 AM

Title: How to check not data in ReportStudio 8.2?
Post by: lostmytoy on 09 Dec 2009 09:00:16 AM
Unlike 8.3 ReportStudio 8.2 doesn't have "No Data property" so how to check for no data.  Basically I need to show zero when no data return from a query. I tried to check RowNumber() with text item in conditional block but doesn't seem to work.

Any Idea? THx.
Title: Re: How to check not data in ReportStudio 8.2?
Post by: Sreeni P on 09 Dec 2009 12:08:26 PM
Hi lostmytoy,

check if the data item having the data or not in particular column..if not hard code with your choice values..

i.e,
if(data_item == "")
then
data_item(hard code value)
else
data_item

by the way it's not an best approach to solve the problem in this way, try to explore in some more ways to solve this problem