Skip to Content
avatar image
Former Member

View SQL Query in SAP Crystal Reports 2013

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"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 19, 2017 at 10:00 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded