Sort Query Results
These steps explain how to sort the data in your Query report.
-
The term field may also be referred to as column in the context of Queries. For details, refer to the online course CMS 100 - Report Builder: Canned Query.
-
Launch Tool #100 CU*BASE Report Builder (Query).
-
Select the desired options on the Build a Report screen.
-
Click the forward arrow.
-
Select the desired report options on the Report Builder - Main Menu screen.
-
Click Choose How Data Should Be Sorted.
-
On the Select Sort Fields screen, select the field you'd like to sort by placing a number in the Priority box to the left of the field name.
-
To sort multiple fields, place them in order using multiples of 1.
-
-
Select the desired sort option from the drop-down menu in the Sort column.
-
Repeat steps 7-8 for all fields you'd like to sort.
-
Click the forward arrow.
-
Click the forward arrow again to confirm.