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

Hide empty graph

Started by Larissa, 15 Apr 2010 06:55:16 AM

Previous topic - Next topic

Larissa

Hi all,

I'm new in Report Studio and I'm facing the following situation that I hope you can help me.

I'm trying to hide an empty chart, because it's showing in my report when there's no data.

I've used conditional block with several different conditions with a boolean variable, but nothing worked.

     - count (QUERY ITEM) > 0 or count (QUERY ITEM) = 0
     - (QUERY ITEM) is null or is not null

I'm not sure how to identify when the query is null in report studio or what kind of data Report Studio retrieve when is null.
My version is MR4 1.1. Is it possible to do this??

Thank's a lot.

pratyush

Hi

Well u can use the row count function instead of count .....! The other way around is to have a style variable instead of conditional variable ..... !

Cheers .....

Larissa

#2
Thank's pratyush...

I tried if Row Count and rownumber, but nothing worked.

Sometimes occurred the following error:

CCLAssertError:0:Fatal: Event Context event: CLS, for expression: RowCount()>0, requires a level.  Level specified is empty.

Trace back:

WPBIBusMethod.cpp(201): CCLAssertError: CCL_CAUGHT: WPBIBusMethod::runRequest
WPReportExecutionMethod.cpp(185): CCLAssertError: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions
WPExecuteRequestThread.cpp(169): CCLAssertError: WPExecuteRequestThread::checkException
WPEngine.cpp(1028): CCLAssertError:
WPController.cpp(263): CCLAssertError: CCL_RETHROW: WPController::executeRendering()
LWDataRetrievalEngine.cpp(804): CCLAssertError: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets
LWEEventManager/WPEventC.cpp(210): CCLAssertError: CCL_RETHROW:
Core/WRExpression.cpp(209): CCLAssertError: CCL_RETHROW: WRExpression::compile
Core/WRExpression.cpp(150): CCLAssertError: CCL_THROW:


According to the user guide, conditional block should work, because you can use it to hide objects. But it didn't.

How Report Studio recognize the data retrieved from the database in this case? How is the data value when there are empty objects on the page? Null?

sathish_cognos

Hi,
just want to confirm what the spec is?, as far the understanding i hope you are having more than one number of chart and want to show one at a time, if thats the case, then you can place the chart in conditional block and use render variable and box type option(=none) to hide it...
or else if you want to find whether the query item is null, then use the opertor <> in ur expression, i could help u more i get more info, regarding the specs, and how the charts to displayed via prompt something like that...

Larissa

Thank's sathish_cognos,

I opened a request in cognos support and they said this functionality is not possible in my version (I'm using Cognos 7).
I tried a lot with conditional block, but nothing worked.

I could hide the empty chart following the steps of the technote 'How do you hide an empty List or Crosstab on a report'.
It was the only way. 


Thank's

annareddy

HI
I tried, got the solution .
I mentioned the below steps:
Select the chart,go to Properties
Set  the  No data Content Property to Yes
Drag the text item.u can  give " No Data Available for Chart".
Add a null filter for the measure that is used in the chart.
Example : Revenue is not null
thanks,
Annareddy