13-48
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 M anaging Reports
Organizing Report Data
When you sort multiple columns, it is important to understand the order of precedence for the sort. In
Advanced Sort, the first column you select is the primary sorting column. Report data is sorted first by
this column.
If the primary column is Customer and the order is Ascending, for example, the report displays
customers in alphabetical order. If you select Location as the next column and the order is Ascendi ng,
then within each Customer entry, the locations are sorted in ascending order.
If the third column you select is Order Number and the order is Ascending, then within each location,
the order numbers are sorted in ascending order. Figure 13-31 shows the result of this multiple-column
sort.
Figure13-31 Sorting Multiple Columns
If the report uses grouped data, the drop-down lists in Advanced Sort show only the detail columns in
the report, not the columns you used to group the data.