Skip to Content
0

View SQL Query in SAP Crystal Reports 2013

Jan 19, 2017 at 09:57 PM

68

avatar image

Is there a way to just view the SQL query that gets generated by CR 2013?

I've tried going to Database -> Show SQL Query, but it displays the GUI where you have your parameters, not a text of the SQL query. This is a co-worker's crystal reports that was made long ago.

I tried doing a quick, barebones crystal report that only included 2 tables and 2 field in the report and when I try that, the SQL query does appear in text.

So I'm not sure what the difference is, or why I get a GUI in stead.

Here is a link to what I get when I click on "Show SQL Query"

http://imgur.com/a/yCK6Z

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Don Williams
Jan 19, 2017 at 10:00 PM
0

If the report is based on a Stored Procedure before the query can be shown you must give it values. Reason is the SQL being passed to the SP requires the values.

Enter anything, as long as they are in the correct format, you will then see the SQL.

Share
10 |10000 characters needed characters left characters exceeded