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.

[former_member610331 · Accepted solution]

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

[former_member1260201 · Accepted solution]

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

[former_member11696]

crw32.exe is Crystal Reports Designer, whomever created those reports will have it.

If not go here to get a copy of it:

https://www.sap.com/products/crystal-reports.html

Don

[former_member610331]

Hi Robert LeClerc,

Open your specific report in Crystal Reports. Ensure you are connected to database (Crystal Report - Database - Log On or Off Server). Within Crystal Reports, go to Database - Show SQL Query.

(if you see a Database login window, use database account credentials or select `Integrated Security` box)

Regards,

Sam

[former_member1260201]

Hi Sam,

I've been using the Central Management Console and don't see a section for Database nor a way to open the .rpt file. In my searching I saw mention of a crw32.exe and associating the file type to that application but I cannot find that file on my server.

It's Crystal Server 2011

This is the structure I looked for the crw32.exe file.

C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0

I also tried the other Crystal shortcuts to no avail (BI Launch Pad, Lifecycle Management, and Central config manager).

Thanks,

Robert

[former_member11696]

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

[former_member1260201]

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

[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