Report Writer - Sort Options

This topic describes how you can specify the sort sequence of the records printed on a report. For sorted fields, you can specify page breaks and whether to print subtotals.

Tips:

You must define the Sort Options for at least one field for the report.
For general information about using the Report Writer, see the Report Writer - Overview.

Directions:

The Sort Options window displays a list of the fields selected for sorting.

Example: To see an example of the Sort Options window, click More.

Note: The example in this topic is based on the Daily Appointment Report.

Field List: To see the descriptions of the fields in the right-pane list of the Sort Options window, click More.

When you click one of the Sort Options buttons described in the table below, you will see the appropriate entry fields in the right pane.

Sort Options Buttons Note: For more information about buttons, refer to the Button Bar Area topic.
	To clear all sort options for all fields, click Clear Sort Options. Tip: To see details about Clear Sort Options, click Here.
	To add Sort Options for a specific field, click Add Sort Option. Tip: To see the Add a Sort Option prompt options, click Here.
	To insert Sort Options for a new field, click Insert Sort Option. Tip: To see the Insert a Sort Option prompt options, click Here.
	To edit Sort Options for a specific field, click Edit Sort Option. Tip: To see the Edit a Sort Option prompt options, click Here.
	To remove the Sort Options for a specific field, click Remove Sort Option. Tip: To see the Remove a Sort Option prompt options, click Here.
	To permanently save the changes made to the Sort Options click Save, which appears on the Report Writer Button Bar.

Sort Options Field List
Level	Displays the line number, which is used to select a sort field for changes. Note: A maximum of nine sort fields is allowed.
#	Displays the line number of the field (from the Range Options list), which is used to add fields to the sort list.
Field	Displays the field name for your reference.
Sub	Indicates if subtotals should print for each group of records sharing the same value for the field. (Y)es: Prints subtotals for the sort field. (N)o: Does not print subtotals.
Pg	Indicates if a new page with new headings should be started for each group of records sharing the same value for the field. (Y)es: Page break occurs. (N)o: No page break occurs.
A/D	Indicates the sort sequence. A: Ascending order D: Descending order Note: Descending order is allowed only for numeric fields.