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?
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