Joined: 03 Aug 2007
Online Status: Offline
Posts: 5
Topic: Dynamic DataSource 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??
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum