Print Page | Close Window

Set Datasource Location not changing tables DB

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=16538
Printed Date: 21 Apr 2025 at 12:14pm


Topic: Set Datasource Location not changing tables DB
Posted By: stonewall63
Subject: Set Datasource Location not changing tables DB
Date Posted: 23 May 2012 at 9:29am

We use Crystal Reports 2008 with MS SQL Server 2008. There are several instances, Development, Test, Production, all of which have an ODBC driver defined.

 

We use the Set Datasource Location feature to change the instance needed. What’s odd is the database will only change in the properties for the high-level name of the location. It does not change in the underlying tables. We have had to change each of them one at a time. Otherwise when running the new copies of the reports we get the wrong data.

 
This behavior seems rather odd. Shouldn’t the change at the upper level (hope I’m using the right terms) do the trick? Our connection is ODBC (RDO).

 
What do you think?

 
TIA.

 

Brad


Replies:
Posted By: kevlray
Date Posted: 23 May 2012 at 11:41am
This has been an issue for years.  I do not know of a good solution.


Print Page | Close Window