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 chart category based on conditional variable?

Started by DSYMA, 01 Oct 2007 09:15:25 AM

Previous topic - Next topic

DSYMA

Hi all,

Does anyone know if it's possible to hide an entire chart category based on a conditional variable, without using filters on the query?

I have a set of reports that each include a list and a chart.  The list is supposed to show every group (category) and suppress measures if the group's "count" is below a certain number.  I can accomplish this fine using conditional formatting.

However, the chart is expected not to render the group at all if its measure is suppressed in the list.  For performance reasons, I want to render the chart from the same query as the list, rather than using separate queries (otherwise I could simply filter out the groups that shouldn't be rendered).

Does anyone know if this is possible?

almeids

DSYMA-
While I haven't used C8 I can't imagine you'd be able to do this without filtering...but there ought to be a way of filtering at what would be the "Query" level in ReportNet so you only hit the database once (Reportnet construct would be a second query which has your filter and sits on top of a tabular reference to the first query).
If I'm way off base my apologies for butting into C8 space prematurely!
Steve