Crystal report ignoring ODBC server

0
votes

I'm trying to configure Crystal report to read the connection data from an ODBC, so it can read the required database given the system where it's installed.

However, the .rpt always connects to the server where it was created, ignoring the ODBC configuration (or, at least, the server name).

i've tried updating the connection and changing the ODBC, but still asks for the first server were it was connected.

is there any way to check if the connection is embed or to make the report read the whole connection from the ODBC?

This happens with most of the reports i'm working on (about 100). I'm using Sap CR 13, and the reports were migrated from CR 8

Thanks!

1
sql-servercrystal-reportsodbc
Try to update the connection after restarting the crystal reports.... sometimes crystal reports saves the previous connection.... try restarting the CR - Siva
Didn't work :( it still uses the memorized connection. - Zar

1 Answers

0
votes

open CR without a report, go to File, Log On or Off Server and it will open Data Explorer windows. Right there you can delete your old connection(right click on the connection and Delete connection) and leave the new one. Then, when you open the report, it should have the new one.

Another thing you can try is going to Database, Set Database Location... and change the old routed table for the new one.