Extract SQL from older unknown Crystal Report .rpt file

5 pts.
Tags:
Crystal Reports
SQL
I have an unknown version of Crystal Report .rpt file. I would like to analyze the SQL only - is it reasonably possible to extract the SQL?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can try this

  1. Open the Crystal Report you want to see the SQL command for, and click on Database Expert button or Database>Database Expert Menu.
  2. Under Selected Tables, right click on the Command and choose View Command
  3. The Data Source Selection Box appears. Select the Data Source you created (or one you already use) and click the Finish button. The View Command box should open with the SQL in the left pane. Copy the SQL into your favorite text editor.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: