Set Datasource Location does not update properly on Crystal Subreports
I have a customer who is having great difficulty switching between Development, Test, and Produstion database environments in Crystal (version 10.0.0.533). FYI, Connecting via ODBC to SQL Server databases.
When using the Set Datasource Location option to switch databases (e.g. from Test to Development), the updates do not always propogate to the subreports. Some subreports will continue to point to the original database (e.g. Test) instead of the new database (e.g. Development).
It's very frustrating for us! We use the Set Datasource Location for Crystal Reports design and testing.
Anyone see this before? Any ideas on how to fix or workaround it?
Abhilash Kumar replied
When you do a 'set datasource location', make sure you select each table from the original datasource and the new datasource and then hit the update button.
Trying to change the datasource by clicking on the connection names doesn't really work well.
In case of subreports too, make sure you update each table as opposed to just updating the connection.
Hope this helps!