13-47
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 Managing Reports
Organizing Report Data
Selecting a Column from a Merged Column
You can aggregate, filter, and group data in a column that contains data that is merged from multiple
columns. You must first select one of the columns on which to aggregate, filter, or group data.
To select one column from a merged column,
Step1 Select and right-click the merged column, then select a command to apply from the context menu, such
as Aggregation, Filter > Filter, or Group > Add Group.
The Select data item dialog box appears.
Step2 From the Select data drop-down list, select the column name to which you want to apply the command,
then click Apply.
If you must provide more information to apply a command, Interactive Viewer displays a dialog box . For
example, if you choose Aggregation, the Aggregation dialog box a ppears.
Sorting Data
When you place data in a report design, the data source determines the default sort order for the data
rows. If the data source sorts a column in ascending order, the column is sorted in ascending order in the
design. Typically, however, data appears randomly in the data source.
A column is likely to display customer names, for example, in the order in which the customers were
added to the database, rather than in alphabetical order. Sorting data, therefore, is an important task in
creating a useful report.
There are three ways to sort data:
•Sorting a Single Column, page 13-47
•Sorting Multiple Columns, page13-47
Sorting a Single Column
To perform a simple sort on a single column, select a column and select either Sort Ascending or Sort
Descending. All the data rows in the report adjust to reflect the new sort order.
To return the data to its original order after performing a simple sort, choose Undo.
Sorting Multiple Columns
You can sort multiple columns in a report.
Step1 Select and right-click a column.
Step2 From the Context menu, select Sort > Advanced Sort.
Step3 Select a column from the first drop-down list and choose either Ascending or Descendi ng order. Select
the next column and choose a sort order, and so on.