Print Page | Close Window

Changing datasource

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=22189
Printed Date: 02 May 2024 at 7:21am


Topic: Changing datasource
Posted By: mknops
Subject: Changing datasource
Date Posted: 11 Jan 2017 at 6:47am
We are using Crystal with Syspro, and are in the midst of upgrading to the new version. We have the test install of SYSPRO 7 up and running; I am currently working on updating our custom reports to the tables for the 7 database. I am hoping there is a way to get the datasource change to propagate down to the table level. I changed the datasource to the new database and ran 'verify database', however when I look at the table properties the catalog still shows 'old' database. Is there a way to get the tables to switch along with the database?

SRS version - 7.0.0.10
Crystal - 2013 SP6 version 14.1.6.1702

-------------
Mark



Replies:
Posted By: kevlray
Date Posted: 11 Jan 2017 at 7:43am
Unfortunately I have seen this from time to time.  You have to update each table (one by one).  It can be really annoying and time consuming.  I do not know any way around it.



Print Page | Close Window