[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Retrieving SQL from .rpt file.

Posted on 2006-05-04
Medium Priority
Last Modified: 2012-05-07
Can I view the SQL used to generate a report from a .rpt file? I am using Crystal Reports 9 and can open the .rpt file, but have no idea where to look for the SQL.  Any help would be appreciated. Thanks
Question by:wjt2003
LVL 26

Accepted Solution

Kurt Reinhardt earned 2000 total points
ID: 16606566
Navigate to Database|Show SQL Query


Author Comment

ID: 16609361
Thanks Kurt, I found the SQL in that very spot. Needless to say I don't use Crystal Reports, but needed the SQL from some .rpt files. Thanks for the quick response!

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question