Cisco Systems CSACS3415K9 Hiding and Filtering Report Data

13-67

User Guide for Cisco Secure Access Control System 5.4

OL-26225-01

Chapter13 Managing Reports

Hiding and Filtering Report Data

To delete an aggregate row:

Step1 Select the calculated column that contains the aggregation you want to remove, then select Aggregation.

The Aggregation dialog box appears, displaying all the ag gregations for the column.

Step2 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.

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 o r sections to display only the column

headings and summary data, such as aggregate data rows.

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 Figure13-42, for example, the Location column

shows the city name each time the name occurs.

Figure13-42 Duplicate Values in Columns

As Figure 13-43 shows, the report is easier to read when duplicate values are not repeated.