Crystal Reports Changing the Data Source

Its easy. Right click on the database fields in your field explorer. Click on 'Set datasource location' And then you will see two sections in a dialog. "Current datasource" and "replace with". In the current datasource - select the object you want to replace. Then in the "Replace with" section click on "create new connection">"OLE DB">Connect to the database object that you want by supplying driver and credential information.

Then click the 'update' button on the right side. That's it! You're done. Though the object name might not seem to change in the 'current datasource' section, still if u click on the (+) sign next to the object, the source name will show the new OLEDB object that you used

Try:

1. Adding the OLE DB data source to thereport without deleting the ODBCdata source.
2. Use the Set DatasourceLocation option (from the Databasemenu in the Report Designer) tochange the datasource for the tablefrom the ODBC data source to the OLEDB data source.
3. Then delete the ODBC data source from the report.

Crystal Report 8.5

Click 'Database' menu->Click 'Remove From Report'->Select the tables which you want to remove from the list->click 'Remove' option->Click 'Done'Button.

That's it:)