The procedure for adding a database (i.e. the interface files that contain the selected fields) to a Crystal Reports report is described below.
1. Select the Visual Linking Expert option in the Crystal Reports Designer's Database menu.
The Visual Linking Expert dialog box is displayed.
2. Click on the Tables button:
The Choose Tables To Use In Visual Linking dialog box will appear.
3. Click on the Add Table button:
The Data Explorer dialog box is displayed.
4. In the tree view, expand the More Data Sources folder, then choose Active Data .
5. Double-click on "Active Data (Field Definitions Only)".
The Select Data Source dialog box will appear.
6. Click on the Browse button for the Data Definition radio button.
7. In the Select Data Definition File box, open the directory defined in the system variable TEMP (whose length must not exceed 248 characters), and then the sub-directory with the same name as the current Adelia environment and finally the sub-directory with the same name as the template code for the program currently being edited. Select the " .ttx" interface file for the required entity. Then click on the Open button.
8. The Data Explorer dialog box will reappear, with the new table selected. Click on the Add button.
- If there is only one entry in the SQL Databases list, click on Close .
- Otherwise, double-click on Make New Connection to return to the Select Data Source dialog box (step 5).
9. The Choose Tables To Use In Visual Linking dialog box will be displayed again. Click on OK .
10. The Visual Linking Expert dialog box will then be displayed, with the new table.
11. Click on OK .
The entity will now be incorporated into the report and you will be able to place all its component fields using the Database Field option in the Insert menu.