In a DataWindow column, you may want to suppress repeating values.  For example, if you have sorted employees by status, you might want to suppress the status when it is the same for two or more employees.

When you suppress a repeating value, the value displays at the start of each new page and, if you are using group levels, each time a value changes in a higher group level.

To suppress repeating values in a DataWindow:

1. Select Suppress Repeating Values from the Rows Menu.  The Specify Repeating Value Suppression List window displays two lists:

A list of columns and graphic objects that are currently selected

A list of columns and named graphic objects that you can select

2. Click the names of the columns or objects for which you want to suppress the repeating values.  PowerBuilder displays the names in the Current List of Column/Graphic Objects list box and highlights them in the Current List of Column/Graphic Objects list box.

TIP:   To remove a column or graphic object from the current list of columns and graphic objects, click the name of the column in the Select/Deselect Column/Graphic Objects list box.  PowerBuilder removes the name from the current list of columns and graphic objects and no longer highlights the name.

3. Click OK when you have specified all the columns or graphic objects for which you want to suppress repeating values.  The DataWindow workspace displays.