Cisco Systems OL-24201-01 Camera Accessories User Manual


 
13-47
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Organizing Report Data
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, page 13-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.
Step 1 Select and right-click a column.
Step 2 From the Context menu, select Sort > Advanced Sort.
Step 3 Select a column from the first drop-down list and choose either Ascending or Descending order. Select
the next column and choose a sort order, and so on.
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 Ascending,
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.