User`s guide

Note:
You can also enable or disable this option quickly by selecting or deselecting Perform Grouping on
Server on the Database menu as needed. If Use Indexes or Server for Speed is not selected in the
Report Options dialog box, this command is inactive.
23.7 Mapping database fields
The Map Fields dialog box allows you to link report fields to their corresponding database fields when
you have made changes to the structure of the database, or when you have created a report based on
one database from a template of another report based on some other database that has the same table
and field structure. In this way, the dialog box helps you to make sure your reports print with the current
version of the active database.
When you first create a report, the report draws its fields from the database as it exists at the time. If
you change the structure of the database after you create the report, the program needs to adapt the
report to the new structure.
23.7.1 About the Map Fields dialog box
The Map Fields dialog box contains four boxes:
• The upper-left box displays the names of all unmapped report fields (for which the program detects
a change in the active database). The top name is selected by default.
• The upper-right box displays the names of unmapped database fields (in which the program detects
a change). Since the Match Type box is selected by default, this box displays only the names of
unmapped database fields of the same type as the unmapped report field you selected in the
upper-left box. To display all unmapped database fields, regardless of type, clear the Match Type
box.
• The lower-left box displays the names of mapped report fields. When you map fields in the upper
boxes, they appear in the lower boxes.
• The lower-right box displays the names of mapped database fields. When you map fields in the
upper boxes, they appear in the lower boxes.
For each database field that you have changed, highlight the report field and the database field in the
upper sections and click Map. The field names move from the upper boxes to the lower boxes.
You do not have to remap every report field. For example, if you delete a database field, it is not
necessary to remap its corresponding report field, since you will not need that field in your report. You
can click OK to close the dialog box without remapping each field listed in the upper-left box.
2012-03-14547
Understanding Databases