Compare the same field to itselft to find duplicates

[vblack7770]

I am working in Crystal 8.5 with Oracle ODBC connection. I need to compare two records together in the details section and if a record1.field <> record2.field, I want to suppress both records. I only want to show both records if record1.field and record2.field are = to one another.

 

[lbass]

If you want to display duplicates, then first group on {table.field}, and then go to report->edit selection formulas->GROUP and enter:

count({table.field},{table.field}) > 1

-LB