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 Report Expert option in the Crystal Reports Designer's Report menu.
The Standard Report Expert will then be displayed. The Data tab shows the list of entities already assigned to the report.
2. To add a new table, click on the Database button.
The Data Explorer dialog box will then be displayed.
3. In the tree view, expand the More Data Sources folder, then choose Active Data .
4. Double-click on "Active Data (Field Definitions Only)".
The Select Data Source dialog box will appear.
5. Click on the Browse button for the Data Definition radio button.
6. 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.
7. The Select Data Definition Fil box will reappear. Click on the OK 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 Standard Report Expert dialog box will then be displayed, with the new table. Click on Next to add fields to the report. Fill in the other tabs if required.
10. Click on Finish , in order to validate the report.
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.