Skip to Content

Removing duplicates

Jul 21, 2017 at 03:49 PM


avatar image
Former Member


In Crystal Reports 10 or latest ver.. I am trying to remove the duplicate quote numbers. As shown in my attached photos.

I have already tried a few methods.. i.e below. I used section expert formula, suppress and even placing this into formula fields and dropping it into details.

{ID} = previous({ID}) and {rental} = previous({rental})

I have tried using Form Field > Common > Suppress If Duplicated.

Trying either everything stays the same, like it ignores or something. Am I not doing this correctly or missing steps? Thanks

dupeq.png (4.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Jul 21, 2017 at 07:05 PM


I kept at it.

What I needed to do in my case was Database > Select Distinct Records. All the duplicates disappear.

10 |10000 characters needed characters left characters exceeded