Crystal Reports  

Selecting a Database

To make changes to the data source of a report, right-click in the Crystal Reports ActiveX Designer and select Database Expert from the shortcut menu.

You can then manipulate a data source by re-linking tables, adding and removing a database, setting a database location, verifying a database, and converting to a different database driver.

To select a database

  1. Right-click Database Fields in the Field Explorer and click Database Expert.
  2. In the Database Expert dialog box, browse the folders to find your data source tables.
  3. Select the tables that contain the data you want to report on and click OK.
    Tip   Instead of selecting the tables, double-click the Add Command node to enter an SQL query.
  4. In the Links tab, click Auto-Link to automatically link the database tables, or click and drag a database field from one table to another table to create a manual link.
  5. If you have linked more than two tables, click Order Links to arrange the links in the order you would like them to be processed.
  6. Click OK.

    The database tables you selected now appear under the Database Fields in the Field Explorer.

See Also

Defining Virtual Tables Based on a Command/SQL Query | Linking Database Tables | Inserting Database Fields