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