My groups are by Customer, not Cities
there are 7 rows of details in Group1 Customer ABC:
3 are Chicago
2 are Miami
2 are New York.
Distinct count of Address.City, for each record, on change of group#1
RTCities = 3, placed in the GF1
Conditionally suppressing Address.City Field in Details, RTCities = 1
Results:
The city name Chicago is supressed (as it's distinct count = 1)
The city name Miami is Visible (as it's distinct count = 2)
The city name New York is Visible (as it's distinct count = 3)
However, in this case I want ALL city names visible.
The only time I want all city names suppressed is when all 7 are the same city.
It's a suppress all addess.city or none, never just some.
If Maximum(RTCities = 1) would work, that is what I'm after!
Edited by carstowal - 16 Mar 2010 at 3:41am