Change SQL statement
I would like to manually change the SQL statement that Crystal Reports 2008 generates (I am using several Oracle tables and views in my reports).
Where is this possible? I can show the SQL statement in the database menu but can't modify it there.
Don Williams replied
After CR 8.5 yo can no longer edit the SQL directly. What we did was to create a Command Object which allows you to paste in or write your SQL. The REprots then use it as the data source.
As Ian suggested, open up your existing reports, copy the SQL from the Show SQL menu option. Create a new report and in the Database Wizard you'll see a Command. Select it, paste in the SQL and then copy the Objects from the old report into the new report.
Unfortunately there is no Set Location option to go from a report based on a direct connection to a Command object. Only way is to recreate your reports.