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. Choose the Add Database to Report option in the Crystal Reports Designer's Database menu.
The Data Explorer dialog box will then be displayed.
2. In the tree view, expand the More Data Sources folder, then choose Active Data .
3. Double-click on "Active Data (Field Definitions Only)".
The Select Data Source dialog box will appear.
4. Click on the Browse button for the Data Definition radio button.
5. 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.
6. 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 4).
7. The Visual Linking Expert dialog box will then be displayed, with the new table.
Note: By default, the tables are identified by the "_ttx" suffix.
8. 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.