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,222

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

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

0 Kudos

Hi Don,

One of our engineers is asking, we use Crystal 2011 for reporting on our ERP system. I can log into the database with no issue so I guess I'll grab the SDK and give that a go.

Thanks

Robert