Changing the database location in Crystal Reports10 1

[mattbrenn]

Hi,
I’m currently hooked up to a SQL test DB for testing a report, all works well so its time to switch to the live database. I’ve used the set data source location option to change to the live DB, which it has. However no data is then returned form the report. When I ‘Show SQL Query’ its still addresses the test database in the statement, hence the lack data on the report.
Any ideas on how to propagate the changes so that the SQL statement update to point to the correct DB.

TIA
M@

 

[vidru]

Have a look at this:

http://support.businessobjects.com/library/kbase/articles/c2014760.asp

-dave

 

[mattbrenn]

Thanks for that works a treat!!