Print Page | Close Window

Set Database Location - Stopped working

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=19492
Printed Date: 19 Apr 2025 at 1:00pm


Topic: Set Database Location - Stopped working
Posted By: Sunapee
Subject: Set Database Location - Stopped working
Date Posted: 02 May 2013 at 6:36pm
I am using Crystal v14.0.4.738 and have many reports that connect to a 2005 SQL server via OLE DB(ADO).

I usually test reports on a small database, then use the menu Database -> Set Datasource Location to point the report to an identical database from one of our customers.  I select the server name in the top section, then the server name of another database connection in the bottom section, press the Update button and close.  Now, the report is reading the customer database.

Suddenly, this stopped working.  I was in the middle of lots of report changes and Setting the datasource location without incident when it stopped working. The properties of each table I am using all say they are pointing to the new tables, but the data is from the original table.  The only way I can change data sources is to do it table by table.  Considering that there are MANY tables in the report, this is a royal pain!

I have tried logging off the server in crystal, restarting crystal, creating a new report with one table and testing on it, uninstalled & reinstalled crystal - all to no avail.

What am I missing?


Replies:
Posted By: praveeng
Date Posted: 13 Jun 2013 at 11:38pm
Hi Sunapee,
 
Try the below step it may help you..
 
Close the Preview tab and update the datasource using Set Datasource Location.
Best Practice is to change the datasource table by table..
 
--Praveen G


-------------
Praveen Guntuka,
praveen_guntuka@yahoo.com

Posted By: Sunapee
Date Posted: 14 Jun 2013 at 3:03am
Originally posted by praveeng

Hi Sunapee,
 
Try the below step it may help you..
 
Close the Preview tab and update the datasource using Set Datasource Location.
Best Practice is to change the datasource table by table..
 
--Praveen G

http://www.crystalreportsbook.com/forum/member_profile.asp?PF=13123&FID=6 - praveeng
Praveena,  Thanks for the suggestion!  I think you may have hit the nail on the head. 


Print Page | Close Window