Joined: 23 May 2012
Online Status: Offline
Posts: 11
Topic: Cannot change rpt from SQL Server to Oracle Posted: 16 Jun 2016 at 12:00pm
We are in the process of changing existing reports that (CR 2011 and 2013) that are connected to a SQL Server DB to connect to the same DB, but an Oracle version. We have many reports which used the Command option in the Database Wizard instead of dragging and dropping tables and linking the icons.
Here’s the catch 22:
If we edit the Command SQL and try to make it Oracle compliant, it fails because the report is connected to a SQL Server database.
If we change the Datasource Location to the Oracle database it fails because the SQL in the Command is T-SQL.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 20 Jun 2016 at 4:10am
This is going to take some manual effort.... I would try this:
1. Create the corresponding Oracle command in the report so that you have both the Oracle and the SQL Server command.
2. Now try Set Location to see if Crystal will let you change the location from one command to the other.
3. If that doesn't work, you'll have to walk through all of the formulas and manually change them from one command to the other and then replace any fields that are on the report with the fields from the new command.
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
