Omit duplicates from a found set

[adyf]

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?

[Lee Smith]

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

[adyf]

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

[comment]

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.

[adyf]

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?

[comment]

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