How to enable the Show sql query...

[rajrev]

HI
I want to see the sql statement for a report. How to enable the Show SQL Query... option which is under the main menu Database in CR 8.5.
Thanks,
MK

 

[bdreed35]

If you have a datasource, and fields on your report, then you just need to run the report once to get data on the report. After that, the Shoq SQL query should be enabled.

~Brian

 

[rajrev]

FYI...
All the are farmula fields used in the reports.
MK

 

[rajrev]

Thanks for your reply. Brian, i tried that one, but its not working!!

 

[bdreed35]

What kind of database object(s) are you using? If you are using Tables and/or Views, then you should be able to get some SQL. If you are using a Stored Procedure, then you will just get a call to that procedure, no SELECT statement in the SQL Query Window.

Also, it may have something to do with the driver and the database you are connecting to. Please tell us what driver and database you are using.

~Brian

 

[rajrev]

I'm using the Tables.

(but fields are farmulas ie for example.
cosider a table xxx.lastname, xxx.firstname
I'm using the formula @empname
xxx.lastname+xxx.fristname
... like this all other fields need to change little bit.)

Database DB2 and MS SQL
Driver - ODBC

Need more info please let me know.
Thanks,
MK