Suppressing all but dups

[TEM3]

Using Crystal Reports 8.5 and Oracle 9i tables:

I have a report grouped by one identifying number. The detailed section contains other information. The vast majority of the groups only contain one detail line. However, some groups have two, three or more lines indicating there are multiple records related to the group id. I want to suppress all the single detail groups and only see the groups with dups (multiple detail lines).

Suggestions please??

 

[bdreed35]

Report menu, Group Selection.
Add the following formula, make sure you modify with the proper fields:

Count({table.id_field},{table.id_field}) > 1

~Brian

 

[TEM3]

So easy. I should have thought of that! Thanks.