Crystal Reports – Filter duplicates by field

The following guide describes how to filter (remove) duplicate rows by a particular field.

In this example we are using Crystal Reports 2008 (version 12) to customise the report. The duplicate row is being identified by the ‘First Name’ column.

 

  1. Open the report and select the ‘Preview’ tab
  2. Crystal-FilterDuplicate1
  3. Note the duplicate rows – ‘Robyn’ is listed twice.
  4. Open the ‘Report’ menu then select ‘Section Expert’
  5. Crystal-FilterDuplicate2
  6. Select the ‘Details’ section from the left hand menu
  7. Tick the ‘Suppress No Drill-Down’ option and click on the icon to the right of it
  8. Crystal-FilterDuplicate3
  9. Using the ‘Report Feilds’ list, double click on the field you need to filter. This will update the formula below.
  10. Type =previous( and double click on the field you need to filter again. Type in ) to finish the formula
  11. Your formula should look like:
    {a_w_contacts.FirstName}=previous({a_w_contacts.FirstName})
  12. Click ‘Save and close’ then ‘OK’ to save the changes
  13. Crystal-FilterDuplicate4
  14. The report will now automatically suppress (exclude or filter) a row which is the same as the previous.
  15. Crystal-FilterDuplicate5

Related Articles

4 comments on “Crystal Reports – Filter duplicates by field

  1. Doesn’t suppress any totals field that is associated with this field though unfortunately.
    Totals still include the suppressed figures….

    And , unfortunately I’m too dumb to work out how to do this. (Ditch the adding of suppressed doubled-up figures)

  2. areeeeee whaaaaaaaaa kya baath hee…. wounderful article…. njan ithu nooki nadakkuvayirunnu.. Good.. any way keep it up……… And Thanks a lot…..

Leave a Reply

Your email address will not be published.