Hi

I am relatively new to Crystal but I need to update a report that someone else has written.

I am using ODBC to connect to a SQL Server backend.

I have copied the original report and now wish to link the copy to a new ODBC connection that I have created.

The connection works and I can prove this since I can pull the correct data both from the old connection and from the new connection into Excel and can see that the results from both are as I expected.

However, when I change the data location in Crystal 9 report it says it has done it but then presents me with the data from the old connection!!!

What am I doing wrong?

Roy

I don't know if this will help, but how are you changing the data location?

I believe it should be Database -> Set Datasource location -> Create New Connection -> ODBC -> Pick your new ODBC name

Also have you tried creating a new Crystal report using the new ODBC link? It could be really noddy, but to prove that it works with Crystal and is pointing where you expect.

Also have you unticked Save Data with Report?

Good luck,
Caspar