on 2019 Jun 12 9:15 PM
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.
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This worked perfectly, I was able to extract the SQL after the DB logon. Thank you all!
User | Count |
---|---|
84 | |
29 | |
9 | |
9 | |
8 | |
8 | |
7 | |
6 | |
6 | |
6 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.