Suppressing repeating values
When you sort on a column, there might be several rows with the
same value in one column. You can choose to suppress the repeating
values in that column.
When you suppress a repeating value, the value displays at the
start of each new page and, if you are using groups, each time a value
changes in a higher group.
For example, if you have sorted employees by department ID, you
can suppress all but the first occurrence of each department ID in the
DataWindow object:
To suppress repeating values
-
Select Rows>Suppress Repeating Values from the menu
bar.The Specify Repeating Value Suppression List dialog box
displays:
-
Drag the columns whose repeated values you want to suppress
from the Source Data box to the Suppression List box, and click
OK.If you change your mind
You can remove a column from the suppression list simply
by dragging it and releasing it outside the Suppression List
box.