1215396 - How to set the data source location in Crystal Reports 9 and later

SAP Knowledge Base Article - Public

1215396 - How to set the data source location in Crystal Reports 9 and later

Symptom

In Crystal Reports (CR) 9 and later, how do you set the location of the database off which your report is based?

Resolution

In Crystal Reports 9 and later, there are two ways to set the location of the data source your report points to, depending on your connection type:

For ODBC and Native Connections

1. On the 'Database' menu, click 'Set Datasource Location'.

2. In the 'Current Data Source' section, click the data source to be changed. You must click each individual table in the data source one by one. If the data source is a stored procedure you will not see individual tables.

NOTE

In Crystal Reports 10, XIR1, and XIR2, if you are mapping from a data source such as a stored procedure where the report designer can not determine which fields should be mapped automatically, you will see a 'Mapping' dialog box where you can manually map fields, as in the procedure cited above.

3. In the 'Replace with' section, click the data source you want the report to use.

4. Click 'Update'.

5. Close the 'Set Datasource Location' window.

The report now points to the new location.
 

For Native Connections Only

1. On the 'Database' menu, click 'Set Datasource Location'.

2. In the 'Current Data Source' section, click 'Properties' to expand it and right-click 'Database Name: <path to database>'.

3. Click 'Edit' and then type the path to the

new data source location.

4. Close the 'Set Datasource Location' window.

The report now points to the new location.

 
More Information 
 
For more information on database connectivity, go to http://support.businessobjects.com/search and download the following documents:
  • cr_convert_database_driver.pdf
  • cr_dbconn_troubleshooting.pdf
  • cr9_database_expert.pdf

Keywords

SET LOCATION MANUALLY MANUAL CHANGE DATABASE DATASOURCE SWITCH NEW DIFFERENT Crystal Reports Set Location Changing the database , c2012382 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

SAP Crystal Reports 9.0