Print Page | Close Window

Switching DB's

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14458
Printed Date: 22 Apr 2025 at 4:03pm


Topic: Switching DB's
Posted By: crnoob
Subject: Switching DB's
Date Posted: 22 Sep 2011 at 8:31am
Hello all,

I am unfamiliar with CR and am trying to pick up for an employee who recently left the company.  I have an existing report and all I want to do is have it pull data from another database.  The current report is set to pull data from SQLserver1, DB1, I want to run the report on SQLserver1, DB2

Can anyone provide me directions? (keeping in mind I am new to CR).

I am using CR2008

Thanks!!


Replies:
Posted By: DBlank
Date Posted: 22 Sep 2011 at 8:42am
go to database menu
set datasource location
in the upper section highlight the source (likely an ODBC file)
in the lower section find your new source (likely a differetn ODBC file)
select Update

Posted By: crnoob
Date Posted: 22 Sep 2011 at 9:35am
Thanks DBlank! I thought that was the way to do it.  In fact i had tried that several times before posting.  It turns out that my new ODBC was set up incorrectly.  I am trying to create a new ODBC connection to a SQL server, but all I see in my list of data sourcesunder ODBC is dBASE files, Excel Files, and MS Access Databse.

Any ideas?

Thanks!

Posted By: DBlank
Date Posted: 22 Sep 2011 at 10:11am
sorry, not sure where the problem is on that.

Posted By: crnoob
Date Posted: 22 Sep 2011 at 10:13am
thanks! I had to configur the ODBC connection on my computer in Control Panel-->'Administrative tools'


Print Page | Close Window