This forum is now out of date, for our new forum Click Here
How to see the SQL used for your report
Frequently Asked Question
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:


Mon Jul 13, 2015 8:10 AM


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!



Sat Aug 15, 2015 4:12 AM

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,



Fri Aug 21, 2015 8:55 AM