I'm looking for a way to remove duplicate records that have an identical value in one of the fields (X) across the found set. It doesn't matter which duplicate records are omitted as I only want to use the said field (X) on a report. I only want unique records to be on display before I go to my report layout. Is there a quick clean way of doing this?

Do you mean omit these duplicate records from the report, or delete them from your files completely?

Hi Lee, just omit from the report not delete completely.

It doesn't matter which duplicate records are omitted as I only want to use the said field (X) on a report.

Perhaps it would be simpler to sort the found records by field (X) and show them in a list layout with a sub-summary part by field (X) and no body part.

Perhaps it would be simpler to sort the found records by field (X) and show them in a list layout with a sub-summary part by field (X) and no body part.

Thanks comment, I see what you mean but my report already has a sub-summary part by another field with field (X) in the body. Is it possible to have two sub-summary parts on a layout with no body?

Yes. Provide more details if you can't make it work.