Cannot change rpt from SQL Server to Oracle
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=22002
Printed Date: 27 Apr 2024 at 6:09am
Topic: Cannot change rpt from SQL Server to Oracle
Posted By: stonewall63
Subject: Cannot change rpt from SQL Server to Oracle
Date 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
|
Replies:
Posted By: hilfy
Date 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
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|