Passing SQL statement to a Crystal Report 1

[RobertMcNeill]

Is there any way to pass an SQL statement to crystal to use to view the report. Instead of the SQL that crystal generates when you create the report.

Thanks

 

[strom99]

Database > Show SQL Query

 

[MalcolmW]

Several ways:
Database|Show SQL Query will pop up the existing SQL statement, but you are limited to what you can do with it. For example, you cannot save direct changes to the SELECT portion of the query.
You can base a report on a query that you can build in the Crystal Query tool. Here, you have control over the full SQL statement.
Personally, I use stored procedures cause they deliver the performance and are easy to maintain. However, they do take a bit more time to do in some cases, especially for reports that require only simple SQL. Malcolm
Remember, if it wasn't for electricity, we'd be surfing the net by candlelight.