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
Crystal Reports Designer first
sorts the records based on the values in the first field selected, putting them
in ascending or descending order as specified. If two or more records have a
matching field value in the first sort field, the matching records are sorted
by 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.