Hi Elyse: I think you may be out of luck, but I'll let the others chime in here.
BTW, you can configure your Crystal Reports (in V11 anyway) to dynamically pull the ODBC settings from the ODBC connection instead of embedding them in each Crystal report. That way, they are not "hard coded" in the report. This allows you to move reports between dev/test/prod without having to change hostnames, ports, etc. (as long as the ODBC connection name is the same). It might be a good idea to make this change across the board as a one-time "bite the bullet" to alleviate any further changes. Terry -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Elyse Bond Sent: September-20-13 8:29 AM To: [email protected] Subject: Crystal Reports - AR System ODBC Database Connection Hi, We are wondering if there is any way to change the database connection in bulk on Crystal reports that use the AR System ODBC driver. I know we can go into the CMC application and change the connection for all reports there, but it doesn't seem to accept the settings for the ODBC driver due to the additional configuration settings (the server name, port number, etc.). The only way we have found to set the connection correctly is via the Database Expert on each individual report. We are having to change the password for our database connection on 700+ reports, and would really rather not change them all one at a time... Any help would be greatly appreciated! Thank you. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
