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.

  1. Launch Tool #100 CU*BASE Report Builder (Query).

  2. Select the desired options on the Build a Report screen.

  3. Click the forward arrow.

  4. Select the desired files, fields, records, and sorting options on the Report Builder - Main Menu screen.

  5. Click Format Columns.

  6. 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.

  7. Ensure that the Edit option is set to Numeric Editing on the Define Numeric Field Editing screen.

  8. Click the forward arrow.

  9. Select the desired options on the Describe Numeric Field Editing screen.

  10. Click the forward arrow.

Learn More

Learn more about the CU*BASE Report Builder feature.