Editing SQL Statements in CR 9.0

[jmeehan]

Seems like the ability to edit a SQL Statement in CR 8.5 has been taken away in CR 9.0. I need to edit the statement but have been unable to find a way to do so.

 

[GMcNamara]

You were never really able to fully edit the SQL in 8.5, just the WHERE clause. But in 9, you can insert SQL Commands that use real SQL, so you can edit your SQL anyway you want. You can update the database through your report. This new functionality in version 9 has allowed me to do things with reports that I would never have considered in 8.5.

 

[synapsevampire]

Even in CR 8.5 you could use a custom SQL Statement as the basis for a report by using RDO/ADO.

In CR 9, it's changed. Connect to your data source and select Add Command and paste in your SQL. You can also create and insert parameters directly into the SQL from there.
The old notion of editing SQL in CR 8.5 reports wasn't a good idea anyway because you'd lose the ability to impact the SQL passed by using the Crystal conventional means.

-k