Sorting Definition window: Fields

 


Report Name

Displays the name of the report for which you are defining a sorting method.

Report Table

Displays each table associated with the report, and allows you to select the table containing the field you want to use to specify the sorting order.

Table Fields

Displays the name of each field in the table selected in the Report Table drop-down list. To insert a field into the sorting definition, select it and click Insert. The field name will be added to the Sort By list. You can use fields from any of the report tables to create a sorting method, including fields you haven't placed on the report.

Sort By

Displays the fields that currently make up the sorting definition. The data will be sorted based upon the first field, then, if a secondary sorting order is needed, the second field, and so on.

Fields you insert into the list will be added below the selected item. If no item is selected, fields will be added to the top of the list..

Sorting Options

The Descending and Ignore Case options can be applied to each field in the sorting method. Select each field and mark the option you want to apply to it.

Descending

Specifies whether the field selected in the Sort By list should be sorted in descending order (c, b, a or 3, 2, 1). If you leave Descending unmarked, the data in the field will be sorted in ascending (a, b, c or 1, 2, 3) order.

Ignore Case

Specifies whether data in a string field will be sorted according to whether it was entered in uppercase or lowercase. If you mark Ignore Case, the field's data will be sorted without regard to case. If you leave Ignore Case unmarked, and you are sorting in ascending order, all strings beginning with uppercase letters will appear in alphabetical order, followed by all strings beginning with lowercase letters, also in alphabetical order. In descending order, all of the lowercase strings will appear before the uppercase strings.


Documentation Feedback