COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: kalyan_sekhar1 on 26 Jun 2006 02:30:42 AM

Title: Hiding Graph If there is no data
Post by: kalyan_sekhar1 on 26 Jun 2006 02:30:42 AM
Hi All,

How do i hide the Graph object if there is no data? so that the user wont seee any blank graph.

Thanks
Title: Re: Hiding Graph If there is no data
Post by: mrcool on 27 Jun 2006 05:58:38 AM
Hi...using conditional block mau solve ur problem...
Title: Re: Hiding Graph If there is no data
Post by: bdybldr on 28 Jun 2006 09:15:21 AM
Check out knowledge base #1012873 on cognos support.  I've tried it with a list report but it should work with a graph also.  Let us know how it goes.
Title: Re: Hiding Graph If there is no data
Post by: kalyan_sekhar1 on 29 Jun 2006 01:49:09 AM
Hi All,

I tried with Codnitional block only. And assigned the Yes/No conditions. But its not hiding if there is no data. Please find the attached txt file

thanks

Title: Re: Hiding Graph If there is no data
Post by: Desperado on 29 Jun 2006 07:14:10 AM
this works ..check it
Title: Re: Hiding Graph If there is no data
Post by: kalyan_sekhar1 on 29 Jun 2006 02:20:15 PM
Hi all,

I followed in the same way as mentioned by Desperado. It works fine when there is data, but when there is no data it is throwing the error

CCLAssertError:0:Fatal: Event Context event: CLS, for expression: count([OPENDATETIME] for report) is null, requires a level.  Level specified is empty.

Trace back:

WPBIBusMethod.cpp(194): CCLAssertError: CCL_CAUGHT: WPBIBusMethod::run

WPReportExecutionMethod.cpp(184): CCLAssertError: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

Thanks