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

[former_member1260201]

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.

[venp81]

Hi don.williams

Any idea if the SQL for a crystal report gets captured in log files? I was trying to track it in cr2020 processing server glf files under \installfolder\Logging directory on the server but nothing shows up there.

Version: BI4.3 SP2

Thanks

Venkat