CCNC/CCNC Module 5/Creating reports/Basic Reporting/Choosing The Data

Choosing the source table
From the Table or queries drop down list choose the table or query to base the report upon 

Choosing the source fields
Once the source has been selected the available fields can be moved to be fields in the report by selecting the field and then selecting the > to move the field into the report. The option available in the Field Selection step of the Report Wizard allow the following actions;

# > - move the highlighted field # >> - move all the fields # < - remove the highlighted field from the report # << - remove all the fields from the report



Ordering the fields
The order of the fields on the report can be changed by using the up-arrow and down-arrow buttons on the right of the wizard dialog box.

Click on the Next button to go to the second screen of the Wizard. 

Labeling the fields
Sometimes it is useful to add labels to the fields. This is particularly true when the field names of the table are not easily understood or an existing database is being used with a different country and language. Labels can be associated with every field on the report to assist in the reports comprehension.  

Test your knowledge
