Dynamic 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=1118
Printed Date: 05 Apr 2025 at 5:37am
Topic: Dynamic DataSource
Posted By: Nainar
Subject: Dynamic DataSource
Date Posted: 05 Aug 2007 at 9:33pm
Hi
I'm delveoping reports using Crystal Report XI R in my development server. After this, I need to deliver/export all the reports to other servers for testing and production. Now I am changing Datasource details (am using ODBC connection to connect Oracle 9i DB) when I put in other servers by opening reports. Is there any way to update the datasource location once for all reports??
Thanks in advance.
Nainar
|
Replies:
Posted By: BrianBischof
Date Posted: 05 Aug 2007 at 10:24pm
No, you can't do this. One thing that occurred to me (but I've never tried), is to keep the System DSN name the same, but change where it connects to. If all reports use the same System DSN, then changing it will change all the reports. If that doesn't work, there isn't any way to do for all reports at once.
-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
|