Print Page | Close Window

how to change the connection string

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3902
Printed Date: 29 Apr 2024 at 9:31am


Topic: how to change the connection string
Posted By: Ashok
Subject: how to change the connection string
Date Posted: 05 Aug 2008 at 8:07am

While I created a crystal report, I develop the report by connecting to Development Environment.(Username, Pwd, conn_dev)

 

Now I want to migrate the report to Test environment. Could some one advice me how to switch the only connection string (conn_test). So that I can use the design part same as the Developement.

 

Thanks for looking into.

 

Thanks,


Replies:
Posted By: rahulwalawalkar
Date Posted: 06 Aug 2008 at 5:37am
Hi
 
Open the report then go to Database Menu -Select Set Datasource Location you will see the current connection settings depends which connection you are using like ODBC,OLEDB etc....
 
below you will find Replace with connection panel create a new connection which connects to your testing enviorment
 
then highlight the production connection and testing connection by selecting it
 
then click Update
 
 
cheers
Rahul

Posted By: Ashok
Date Posted: 19 Aug 2008 at 5:41pm
Thank you. Let me try this option and will update you the results.

Posted By: Ashok
Date Posted: 22 Aug 2008 at 12:23pm

Thanks its worked !!! there is an update button on the same screen.

once again thaks for your responce


Print Page | Close Window