HP Intelligent Management Center Standard Software Platform - Manual (Page 215)

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).
To create a Sort Control
1.
Once the data is grouped, on the Report menu, click Record Sort
Expert.
The "Record Sort Expert" appears.
Crystal Reports 2008 SP3 User's Guide 215
10 Sorting, Grouping, and Totaling
Sorting data