Suppressing duplicate values
Sometimes a report column displays duplicate values in consecutive data rows. When the duplication is unnecessary or makes the report difficult to read, it is useful to suppress consecutive duplicate values. You can use Report Studio to suppress duplicate values that appear in a grouped column by moving data rows from the column to the group header.
Avoiding repeated values in a column
In the report shown in Figure 9‑10, the Location column shows the state name each time the name occurs.
Figure 9‑10 Viewing duplicate values in columns
As Figure 9‑11 shows, the report appears neater and more organized when duplicate values are not repeated.
If a column extends across multiple pages, the first row on each page displays a value, even if duplicate values are suppressed for that column.
Figure 9‑11 Viewing a report with suppressed duplicate values
How to suppress duplicate values in a column
Select and right‑click the column containing duplicate values. Choose ColumnDo Not Repeat Values.
How to show hidden duplicate values in a column
Select and right‑click a column that does not repeat duplicate values. Choose ColumnRepeat Values.
Avoiding repeated values in a group
In a grouped column containing repeated values, you can avoid repetition by moving the data row values to the group header so that they only appear once.
How to suppress duplicate values in a grouped column
1 Select and right‑click the column with the duplicate values. Choose ColumnMove to Group Header.
2 In Move to Group Header, as shown in Figure 9‑12, select the group to which you want to move the data values, if the report contains more than one group.
Figure 9‑12 Selecting a group header
Choose OK.
Repeat steps 1 and 2 for each report column for which you want to move data rows to the group header. The value from the first data row in each group appears in each group header. The Product Line column displays a single data row for each Customer Number group header, as shown in Figure 9‑13.
Figure 9‑13 Viewing a report that suppresses duplicate values in a group