Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 01 Feb 2007 at 11:07am
Yes, to change the Crystal Reports data provider at runtime you have to use the ReportDocment object model and change the properties ServerName and DatabaseName to the Oracle database. Unfortunately, I've never used Oracle before so I don't know if there are any special quirks that might trip you up.
Edited by BrianBischof - 01 Feb 2007 at 11:07am
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>
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 01 Feb 2007 at 1:05pm
If you used a Command Text to set the query for the report, you're probably ok. If you used the Database Expert to select tables and link them, you may have problems due to the table owner being included in the SQL. Use the Database menu option "Show SQL Query" to take a look at the SQL in your report. If there is "sa." in front of the table names, just changing the driver will not work because sa is not a valid table owner in Oracle.
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
IP Logged
