CCNC/CCNC Module 5/Creating reports/Basic Reporting/Choosing The Data
Choosing and setting the reports data source
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