Sorting
To specify the sort order within a section, access the Query/Sort Section Properties. Then, select the option to Display objects in a particular order, and click the Click to specify the sort option to open the Sort Designer.
The Available Fields Palette opens, where you can select fields for the sort.
Example
To sort transactions using the transaction type, select myTransaction.tranType from the database field list (which displays relative to the selected section). Then, drag the field into the designer:
Select a sort order of Ascending or Descending. The section sort order uses the order that lines are added to this designer form.
To add a sub-total about the sort, select Yes in the Break section. When the sub-total option is selected for the section, a sub-total displays based on the sort break.
Note: Sort orders are defined at a profile level, so the sort conditions is attached to the profile that is selected on the main toolbar at setup.
Sorting within Multiple Repeating Sections
When a report prints, it always takes a single instance of the parent section (outer) and then works through all instances of the child section (inner). The sort order for an outer section is unaffected by the sort order set for an inner section.
For example, if you have a parent (outer) section from a JC timesheet, and a child (inner) section based on cost lines, the report outputs information using the primary sort of the parent (in this case, employee), followed by a secondary sort within the employee that could be based on one of the cost line attributes, such as document date or activity code.