Suppress Groups of Data and Keep Groups of Issues Only

[FireGeek21]

I am trying to find a group set of data that have problems and suppress group sets that are not a problem. In the sample dadata below, group sets A & B are issues because the second column is not the same all the way through. Group sets C & D are ok. How can I identify and keep group sets like A & B and suppress group sets like C & D?

SAMPLE DATA:

A 0000
A 1000
A 1000

B 0000
B 0000
B 1000
B 1000

C 0000
C 0000

D 1000

FireGeek
(currently using Crystal Reports XI with Lawson 9.01)

 

[BobSuruncle]

You could try something like this:
Create a DistinctCount on the column that is supposed to be the same.

Then in the Group Selection formula, tell it to show only groups where the DistinctCount is greater than 1.

e.g.
DistinctCount({YourTable.YourSameField},{YourTable.YourGroupingField}) > 1

Bob Suruncle

 

[FireGeek21]

That worked! Thank you! Sometimes when you look at something for so long, you cannot see the obvious/simple solution!!!

FireGeek
(currently using Crystal Reports XI with Lawson 9.01)