Suppressing Duplicates



  1. The Meetings report is displayed. Notice that the Subject and Cat# (Catalog Number) fields have several values that appear multiple number of times.

    Step 1
  2. To suppress the duplicate values, navigate to the Design page.


    Click the Design tab.

    Step 2
  3. Click in the SUBJECT field.

    Step 3
  4. You use the Format Editor dialog box to suppress the duplicate occurrences of a field.


    Click the Format menu.

    Step 4
  5. Click the Format Field... menu.

    Step 5
  6. The Format Editor dialog box enables you to change the style, type, size, color, and appearance of text and report fields. In this example, you do not need to use the options on the Paragraph tab.


    Click the Common tab.

    Step 6
  7. Use the Suppress If Duplicated check box if you do not want the report to display field values that are duplicated. The field values will not appear on the Preview page, nor will they print.


    Click the Suppress If Duplicated option.

    Step 7
  8. Click the OK button.

    Step 8
  9. Click in the CATALOG_NBR field.

    Step 9
  10. Click the Format menu.

    Step 10
  11. Click the Format Field... menu.

    Step 11
  12. Click the Common tab.

    Step 12
  13. Click the Suppress If Duplicated option.

    Step 13
  14. Click the OK button.

    Step 14
  15. Next, view the report.


    Click the Refresh button.

    Step 15
  16. You are prompted to confirm whether you want to refresh the report data.


    Click the OK button.

    Step 16
  17. Notice that values appear in the Subject column only once. The duplicate values have been suppressed.

    Step 17
  18. Also notice that values appear in the Cat# (Catalog Number) column only once. The duplicate values have been suppressed for this column as well.

    Step 18

You have successfully suppressed duplicate values in a Crystal report.

Table of Contents  Start Topic