Changing the Data Source Location Of any Existing Report in Crystal Report

Use the Set Location command to indicate the new name or location of tables that are active in a report. This is especially useful if someone sends you a report that uses a database that has a different location on your system, or if you have changed the directory or disk location of a database. In addition, the Set Location command automatically converts your database driver to the data source you have chosen. For example, you can automatically convert a direct access data source to an ODBC data source using the Set Location command.

The procedure is the same whether you are replacing all tables from a particular data source with tables of the same name from another data source, or replacing an individual table with another table.

To change the data source location

1. Right-click in the embedded Crystal Reports Designer, point to Database, and click Set Datasource Location.
2. From the Current Data Source list, choose the data source table from which you want to change.
3. In the Replace with list, browse for the new data source.
4. Select the table you want to change to.
5. Click Update.
6. Click Close after you have changed all tables you want to change; otherwise repeat these steps for any unmodified tables or data sources.