Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Cannot change rpt from SQL Server to Oracle Post Reply Post New Topic
Author Message
stonewall63
Newbie
Newbie
Avatar

Joined: 23 May 2012
Online Status: Offline
Posts: 11
Quote stonewall63 Replybullet 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.

We cannot update the report at all.

Any ideas?

Thanks,
Brad
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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.

-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.