How to see the SQL used for your report

How to get/check the SQL generated for your report.

You can view the SQL being run when you generate your report, from the report preview page.

To do this;

1. Run the report, and then go to 'Details'.
2. From here, select the TAB 'SQL Statement'
This will display the SQL, which can then be exported.

See screenshot below:

How to see the SQL used for your report

Hey

Sorry I don't know how to post a new question, I will be grateful if you can tell me that!

Does virtual table support temporary table? The SQL reminds me the syntax mistake near "into". ('into #temp1")when I tried to create a temporary table.

Thanks a lot!

Cathy

Hi Cathy,

I believe that you were able to post this as a NEW forum post and we have since responded.

Please let us know if this is not the case.

Thank you,

Kyle