User`s guide

Sort OrderField Type
chronological orderTime fields
False values (0)
True values (1)
Boolean comparison fields
null values
non-null values
Null values
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.
8.1.1.3 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.
8.1.2 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.
2012-03-14143
Sorting, Grouping, and Totaling