If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to check not data in ReportStudio 8.2?

Started by lostmytoy, 09 Dec 2009 09:00:16 AM

Previous topic - Next topic

lostmytoy

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.

Sreeni P

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