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

 

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