Suppressing Pie-Chart with only one city

[sultan123]

I have graph reflecting sales by city Grouped under Region.

I would like to suppress this chart when a region has only one City in it.

I know it sounds like a conditional suppress format,but anyone please please show me how?

Thank you

 

[kenhamady]

Use the following formula in the suppress condition for the section containing the chart:

DistinctCount ({city},{region}) = 1

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[sultan123]

Thanks Ken
Unfortunately that doesn't work as it results = 1 all the time, here is what the report looks like:

Group Header1a= Regions
Group Header1b= Pie Chart showing sale for number of cities in the above region group. which i want to suppress if a particular region only has one city.

Group Header2: Cities under the above regions
Details:cities
GF2= City
GF1b
GF1a
etc

This DistinctCount ({city},{region}) = 1 suppresses all chart even with Regions with more than 1 city because it always returns 1.

Please note that the chart is in GHeader1b section under the GHeader1a region.

Does this make it clear?

many thanks

 

[kenhamady]

Clear, but doesn't make sense. The formula I gave counts the number of cities in that region. The sections don't matter. If it returns a 1 for every group then there is something wrong with the formula. Could you copy and post the actual suppression formula that you tried?

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com