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
Tip Instead of selecting the tables, double-click the Add Command node to enter an SQL query.
The database tables you selected now appear under the Database Fields in the Field Explorer.
Defining Virtual Tables Based on a Command/SQL Query | Linking Database Tables | Inserting Database Fields