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.
Hi Robert,
Question for you, why do you want the SQL?
The SDK can get it but you need to be logged onto the data source first, because the SQL is dynamic depending on the DB connecting to so we don't save it in the rpt file.
You would need a developer to write the app for you.
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.