Filter
Top Products
13-66
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Hiding and Filtering Report Data
Deleting Aggregate Rows
To delete an aggregate row:
Step 1 Select the calculated column that contains the aggregation you want to remove, then select Aggregation.
The Aggregation dialog box appears, displaying all the aggregations for the column.
Step 2 For the aggregation you want to remove, choose Delete Aggregation, then click Apply.
Hiding and Filtering Report Data
You can decide whether to hide or display data in your report in several ways:
• You can specify whether to hide or display detail rows.
• You can specify that you want to display only one copy of duplicate rows.
• When the data set provides more information than your report needs, you can filter out unwanted
data. You also can enable your users to specify the filter values by using run-time parameters.
Hiding or Displaying Column Data
Frequently, you do not want to display all the data in a report. For example, a column of detail can
display 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 addition, as you design a report, you can collapse groups or sections to display only the column
headings and summary data, such as aggregate data rows.
Suppressing Repeated Values
Before you begin formatting and adjusting the data in your report, data rows appear in the report exactly
as they appear in the data source. In the report shown in Figure 13-42, for example, the Location column
shows the city name each time the name occurs.
Figure 13-42 Duplicate Values in Columns
As Figure 13-43 shows, the report is easier to read when duplicate values are not repeated.