View SQL Code Produced by Crystal

[PrgrmsAll]

When a report is built within Crystal, I assume that in the background SQL Code is generated and that is what is actually executed on the database, for example, Oracle or SQLServer. Is there a way for me to go into the report in Crystal and view this SQL, assuming it exists somewhere?

Thank you in advance.

 

[Turkbear]

HI,
There is, under the Database menu choice, an option called 'Show Sql' - that will do it.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Also keep in mind that a common problem with people building reports is to not assure that SQL is passed from the record selection to the database.

Check out my FAQ on this topic:

faq767-3825

-k