Print Page | Close Window

SQL Command - Set Database Location

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=11557
Printed Date: 01 May 2025 at 10:23pm


Topic: SQL Command - Set Database Location
Posted By: aneeshjk
Subject: SQL Command - Set Database Location
Date Posted: 29 Oct 2010 at 4:26am
Hi,
 
I got some cyrstal reports where it runs in MS-SQL server, where I want to replicate the same reports in Oracle DB. These reports use Command Object where the SQL queries are embedded. The Reports use OLEDB connection.
                   I have modified these queries in Oracle syntax , tried to update in the 'Set DataSource Location'. I tried to keep the updated queries under 'Add Command' of 'Replace with' section. After which I tried to click the 'Update' Button, the new Oracle connection haven't replaced the existing SQL Server connection.
 
 I don't want to change the structure of the report,  just wanted to change only the data source- from SQL Server to Oracle source. My other concern is - Will the fields that were referred in the Design will be retained once the data source is changed ?
 
Can anyone help me in this how to resolve it?
 
Thanks in advance,
Aneesh


Replies:
Posted By: aneeshjk
Date Posted: 31 Oct 2010 at 10:36pm
Appreciate if any of you can help in this issue ?

Posted By: lockwelle
Date Posted: 01 Dec 2010 at 3:31am
I don't know about Oracle, but when changing  connection, I have found that I need to update the connection AND each table.
 
I am pretty sure that if the fields in the report do not map to fields in the datasource that CR will delete them, pretty much without warning.
 
HTH

Posted By: hilfy
Date Posted: 01 Dec 2010 at 11:54am
I haven't had any problems using Set Location to change the database on commands, but I've always done it using the same type of database - i.e., Oracle to Oracle or MS SQL Server to MS SQL Server. 
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window