Print Page - How to Conditionally Render Data based on query results?

Title: How to Conditionally Render Data based on query results?
Post by: GDS on 22 Sep 2009 05:57:54 PM

I am looking to build "exception" based reports ...

DATA SET EXAMPLE

List of cities
List of distributors (with a count subtotal)
List of products

Current Normal Report: Query return shows for any given city, how many distributors as selling a product.

Exeption Report Desired: If we have more than one distributor in a city selling a given product ... show all those distributors for that city ... otherwise hide all other data.

==========

Problem: I seem to be able to set conditions based on data that exists, but I cannot find a way to set something like "render = yes ... if the count of distributors per city/product > 1"

Any thoughts?

Title: Re: How to Conditionally Render Data based on query results?
Post by: lindero on 23 Sep 2009 05:05:12 AM

you have to count all distributors for a city with the OLAP funktion count(distributors for City). If the content of this data item is 1 then box type none else do nothing.

That's an easy way to reach your requirements.

bye

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: GDS on 22 Sep 2009 05:57:54 PM