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, you can suppress consecutive duplicate values in a regular or grouped column. For example, a report that lists customer orders, grouped by customer, shows some data values such as the address, contact information, customer number, and so on, multiple times for every order placed by the customer. You can prevent the duplicate occurrence of these values by moving data rows from the column to the group header.
In addition, as you modify a report, you can collapse groups to display only the column headings and summary data, such as aggregate data rows.
In the report shown in Figure 7‑18, the city and state columns show the city and state each time they occur.
Figure 7‑18 Duplicate values in columns
As Figure 7‑19 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 7‑19 A report suppressing 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.
A report displays the values for the Customer Number and Credit Limit columns multiple times for the same customer. By moving the data row values to the group header, you limit the appearance of these fields of data so that they only appear once, as shown in Figure 7‑20.
Figure 7‑20 A report suppressing duplicate values in a group
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 On Move to Group Header, as shown in Figure 7‑21, perform the following tasks:
*Select the group to which you want to move the data values, if the report contains more than one group.
*Select the header row to which Interactive Viewer should move the data values.
Figure 7‑21 Selecting a group header
Repeat this step for each report column for which you want to move data rows to the group header. Choose OK. The value from the first data row in each group appears in each group header. The Product Line, Customer Number, and Credit Limit columns display a single data row for each Customer Name group header, as shown in Figure 7‑22.
Figure 7‑22 Displaying a report showing suppressed duplicate values