Crystal 2008 Set datasource location for SQL command reports
Posted on 2011-05-10
I have a few Crystal reports for the Lawson ERP which were written on a MS SQL database. The reports are a combination of tables and SQL commands. I need to update the datasource to point to an Oracle 10g data base. I can use the Set Datasource Location to easily map the tables. Does anyone know of a way to update the SQL commands without recreating command? Does anyone know of a way to view the SQL command on a report without connecting to the orginal data source? I tried to use the export report definition command but the SQL is not listed in the report definition.