Operation Manual

Sorting, Grouping, and Totaling
Sorting data
10
Crystal Reports User’s Guide 169
Note: If sorting and grouping are performed on the database server, sort
order may vary when Unicode or UTF-8 data is used. The order applied
depends on the rules in place for your data source. In certain cases, Unicode
data is sorted by its binary value, but it can also be sorted according to a
particular locale setting. Refer to the documentation for your data source for
details on how Unicode data fields are sorted.
Sort Direction
Direction refers to the order in which the values are displayed, once sorted.
• Ascending
Ascending order means smallest to largest (1 to 9, A to Z, False to True).
The program sorts the records in ascending order based on the values in
the sort field you select.
• Descending
Descending order means largest to smallest (9 to 1, Z to A, True to
False). The program sorts the records in descending order based on the
values in the sort field you select.
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.
Currency fields numeric order
Number fields numeric order
Date fields chronological order
DateTime fields chronological order
same-date values sorted by time
Time fields chronological order
Boolean comparison fields False values (0)
True values (1)
Null values null values
non-null values
Field Type Sort Order