Skip to Content
avatar image
Former Member

Removing duplicates

Hello,

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Hi,

    I kept at it.

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

    Add comment
    10|10000 characters needed characters exceeded