beautypg.com

Sorting single and multiple fields, To sort your data – HP Intelligent Management Center Standard Software Platform User Manual

Page 213

background image

Sorting single and multiple fields

In single field sorting, all the records used in the report are sorted based on
the values in a single field. Sorting an inventory report by stock number or
sorting a customer list by customer number are examples of single field sorts.

In multiple field sorts, the Report Designer first sorts the records based on
the values in the first field selected, putting them in ascending or descending
order as specified. When two or more records have the same field value in
the first sort field, the program then sorts those records based on the value
in the second sort field.

For example, if you choose to sort first by the {customer.COUNTRY} field
and then by the {customer.REGION} field, both in ascending order, the report
would appear with countries listed in alphabetic order, and regions within
each country listed in alphabetic order. Any other fields, such as the postal
codes within each region, would remain unsorted.

You create single or multiple field sorts using the same procedure.

To sort your data

1.

On the Report menu, click Record Sort Expert.

The Record Sort Expert appears.

Crystal Reports 2008 SP3 User's Guide

213

10

Sorting, Grouping, and Totaling

Sorting data