How to Conditionally Render Data based on query results?

[GDS]

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?

[lindero]

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