Print Page | Close Window

Connect to different datasource

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=13766
Printed Date: 22 Apr 2025 at 9:38pm


Topic: Connect to different datasource
Posted By: sa-user
Subject: Connect to different datasource
Date Posted: 15 Jul 2011 at 9:25am
HI,

I have developed a report on a database. How will i be able to update database/datasource name to use the same report with a different database?

Thanks


Replies:
Posted By: CrystalDesigner
Date Posted: 15 Jul 2011 at 10:04am

Click on Database (menu item on top of the screen)
click Log on or off Server (Data Explorer window should open up)
Create New Connection
(connect to database server/location)
close the window

Click on Database menu item again
click Set Datasource location
Select the Server Name in "Current Data Source" box:

then select datasource location in "Replace with" box
Click "Update" button (right side of the box)
close the window.

You can now pull the data from your new data source location.
Make sure to set the data source location for Sub Reports too if you have any.

Posted By: sa-user
Date Posted: 15 Jul 2011 at 11:15am
thanks... this works


Print Page | Close Window