User`s guide

Tip:
The order of the fields listed in the Sort fields box is the order by which data will be sorted.
7.
As you add each field to the Sort Fields list, specify the sort direction.
8.
Click OK when finished.
Records are sorted based on the values in the Sort Fields list.
8.1.3 Sort controls
You may want to design your report so that users can modify a sort field or sort direction without
refreshing information from the database. You can do this using a "Sort Control".
A "Sort Control" is particularly useful for several reasons:
• It allows users to sort report data for further analysis without leaving the canvas of the report.
• It eliminates processing demand on the database.
• It reduces the time users spend waiting for data to be sorted.
• It allows users to sort fields in the report even if they do not have a connection or rights to access
the database at the time of viewing.
When planning to include a "Sort Control" in your report, it is important to consider the following points:
• Sort controls apply across an entire record set; you cannot sort only one group.
• Sort controls cannot be used in sub-reports.
• Sort controls cannot be created within a cross-tab or an OLAP grid.
• The use of sort controls causes any open drill-down tabs to close (a warning prompt alerts users).
8.1.3.1 To create a Sort Control
1.
Once the data is grouped, on the Report menu, click Record Sort Expert.
The "Record Sort Expert" appears.
2012-03-14145
Sorting, Grouping, and Totaling