Print Page | Close Window

Connecting to multiple ODBC databases

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=14422
Printed Date: 22 Apr 2025 at 4:03pm


Topic: Connecting to multiple ODBC databases
Posted By: szmorr5
Subject: Connecting to multiple ODBC databases
Date Posted: 20 Sep 2011 at 4:11am
I am trying to add a connection to another database to an already created report-- I have groups and calculations already exsiting in the current report-- the other database connection has the same table name as the one already in the report-- I have never used mulitiple databases in crystal reports.


Replies:
Posted By: CrystalDesigner
Date Posted: 20 Sep 2011 at 7:18am

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.


Print Page | Close Window