1479281 - How to remove duplicate rows from Crystal Reports?

SAP Knowledge Base Article - Public

1479281 - How to remove duplicate rows from Crystal Reports?

Symptom

How to remove duplicate rows from Crystal Reports?

Environment

  • Crystal Reports 2008
  • Crystal Reports XI R2

Resolution

  1. Open the report in Crystal Reports designer
  2. Click on Report >> Section Expert. It opens the Section Expert in a new window
  3. Select Details section on left hand side
  4. On right hand side there is ‘Suppress(no drill-down)’ option on Common tab. Click on [X+2] button in front of it. Formula Editor opens
  5. Write below formula

Previous ({database.field}) = {database.field}

  1. Click on ‘Save & Close’ button to close the formula editor
  2. Now duplicate rows are not visible in the report

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1