Display only groups showing more than one record

[agray123]

I am trying to create a formula/setup that only lists positions that are being shared (only 2 right now out of 2000), however this will change and I want to be able to run a report that checks for shared position numbers.

I set up the report thus far to group by pos number and display name below (along with other demographics).

I know you experts will handle this in about 5 minutes...

 

[dgillz]

In your group footer, place a summary count by group, then in your GROUP selection formula (not record selection formula) place the following:

Count({FieldName},{GroupByName})>1

This will display only groups with at least 2 records. Is this what you want?

Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Naith]

Insert a count function counting keys which are shared. Place the count total in the group footer. Conditionally suppress the group footer section where count value < 2.

This only suppresses the group footer. You won't be able to use this technique if you want to suppress the detail and group header section based on the count value being less than 2.

Naith

 

[agray123]

Yes, and you hit the predicted time window.