There are two ways to do this :
Using the Show SQL Query dialog box :
* Open the Crystal Reports report that you want to edit the SQL for.
* In the Database tab, right-click the query that you want to edit and select Show SQL Query.
* In the Show SQL Query dialog box, you can edit the SQL statement.
* Click OK to save the changes to the SQL statement.
Using the Add Command feature :* Open the Crystal Reports report that you want to edit the SQL for.
* In the Database tab, click the Add Command button.
* In the Add Command dialog box, specify the following settings:
Command type : Select SQL.
Command text: Enter the SQL statement that you want to use.
Data source: Select the data source that you want to use.
* Click OK to create the command.
* In the Database tab, drag and drop the command to the report where you want it to appear.
Once you have edited the SQL statement, you can run the report to see the changes.
Here are some things to keep in mind when editing SQL made by Crystal Reports :
* The changes that you make to the SQL statement will affect all of the reports that use the same query.
* If you are not familiar with SQL, you should consult with a database administrator before making any changes to the SQL statement.
