Format Account Numbers
These steps explain how to make your Query results easier to read by formatting the account numbers.
-
The terms file, field, and record may also be referred to as table, column, and row 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 files, fields, records, and sorting options on the Report Builder - Main Menu screen.
-
Click Format Columns.
-
On the Specify Report Column Formatting screen, click the edit button (pencil icon) button corresponding to the field whose number formatting you'd like to change.
-
Ensure that the Edit option is set to Numeric Editing on the Define Numeric Field Editing screen.
-
Click the forward arrow.
-
Select the desired options on the Describe Numeric Field Editing screen.
-
Click the forward arrow.