CU*BASE Report Builder (Query)
Select Sort Fields
This screen appears when you choose the “Choose how data should be sorted” option on the Report Builder Main Menu.
Check out the video related to this topic: Formatting Dollar Amounts
Learn how to sort Query results.
This screen is used to specify how the data on the report should be sorted.
Only the fields which were chosen on the Choose Report Columns screen will be included in this list, so be sure the fields you wish to sort by have been selected before choosing a sort order.
Using the Prty column, enter sequential numbers to indicate the order in which records should be sorted. For instance, items could be sorted first by branch, then by G/L account number, then date, etc. In the Sort Order column, choose either Ascending (A) or Descending (D) order.
CU*TIP: To make it easier to insert additional sort sequences later, allow a gap between each of the sequential numbers. For example, if the original sequence was 10, 20, 30, and 40, you could later add a field between 10 and 20 by using sequence number 15. Use F20=Renumber to automatically re-sequence and organize your selections using a generic sequence of tens (10, 20, 30, 40, etc.).
When done, use Enter to save changes.
Check out these additional video resources!
Sorting Query Results
Visit the CU*BASE video library.