Select Fields

These steps explain how to complete the second step in creating a custom Query, which is to select fields.

• The terms file and field may also be referred to as table and column  in the context of Queries. For details, refer to the online course CMS 100 - Report Builder: Canned Query.

1. Click Choose Fields on the Report Builder - Main Menu screen after you select a file.  

2. Select the desired fields by placing a number in the Seq boxes on the Select and Sequence Fields screen.

   • The order in which fields will appear in your report will depend on what number you assign each field.

   • It's recommended that you space out your numbers by ten to leave room to enter additional fields in between should you want to do that at a later date.

3. Click the forward arrow to view  the selected fields in order.

4. Click the forward arrow again to confirm your field selections.

Learn More

Learn more about the CU*BASE Report Builder feature.

Learn more about building a query.

Watch a VIDEO showing you how to complete the steps above.