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.
 
- 
                                                
Click Choose Fields on the Report Builder - Main Menu screen after you select a file.
 - 
                                                
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.
 
 - 
                                                        
 - 
                                                
Click the forward arrow to view the selected fields in order.
 - 
                                                
Click the forward arrow again to confirm your field selections.
 
Learn More
                                                         
                                                     | 
                                                    Learn more about the Report Builder feature. | 
                                                         
                                                     | 
                                                    |
                                                         
                                                     |