Cisco Systems OL-24201-01 manual Grouping Data, 13-48

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-32shows the first page of an ungrouped report.

	User Guide for Cisco Secure Access Control System 5.3
13-48	OL-24201-01