13-48
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Organizing Report Data
Figure 13-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.

Grouping Data

A report can contain a great deal of data. Consider the task of listing every item a corporation owns,
along with information such as the purchase price, purchase date, inventory tag number, and the supplier
for each item.
If a report presents all these items in an unorganized list, there is no way to determine how much the
corporation spends for heavy equipment because heavy equipment items are scattered throughout the
report.
The report cannot help you see which supplier sells office furniture at the lowest prices. Nor is it easy to
tell which inventory items are located at a field office and which items are in the warehouse.
Figure 13-32 shows the first page of an ungrouped report.