Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Set Datasource Location does not update properly on Crystal Subreports

Greetings -

I have a customer who is having great difficulty switching between Development, Test, and Produstion database environments in Crystal (version 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?

Thank you,

Eric Kenney

Former Member

Hi Eric,

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!


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question