cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports 2011- How to view SQL query string of a report

0 Kudos
19,330

I am trying to gather the SQL Query that a specific report is using in Crystal Report 2011. I found the report in the CMC but don't see a way to view the SQL query and I also was able to find the associated .rpt file but no way to open the file that I can figure out (I do have SQL access).

1. Is there a way in the CMC or BI Launch Pad to view the reports SQL query?

2. From the .RPT file can I pull the SQL query info if I cannot do it from the CMC or BI launch pad?

3. Is there an easier way to get this info?

Sorry I've exhausted quite a few things I found searching and figured I throw the towel in and ask.

View Entire Topic
former_member610331
Contributor

Hi Robert LeClerc,

I understand. My response is in line with Crystal Reports. I suggest to get 30-day trial version of Crystal Reports using link mentioned in Don Williams`s response.

Once you have trial version, please refer my original response. I have also attached screenshots here, so I hope that helps to address your question.

Once Crystal Reports is installed on your PC/Server:

1. Open your specific report in Crystal Reports.

2. Ensure you are connected to database. Within Crystal Report, click `Database` and `Log On or Off Server`. If you see a Database login window, use database account credentials (`sa` or `manager` or any other user account) Or simply select `Integrated Security` box.

3. Within Crystal Reports, go to Database - Show SQL Query.

4. SQL Query will be displayed.

If your query is answered, kindly mark appropriate response as `answer`.

PS: If trial version does address your query, please don`t forget to purchase Crystal Reports license.

Best wishes & Regards,

Sam

This worked perfectly, I was able to extract the SQL after the DB logon. Thank you all!