Output as SQL

This option formats the output of the query as SQL into a new window. This option allows you to send troubleshooting reports to myDBR support without need to have table structure and all data to be sent. The SQL output is enough to replicate the troublesome report.

To use the option, open the report in question in SQL Editor and check the report parameters:

Go to "Query 1"-tab and fill in the parameters you wish to use and check the "Output as SQL"-checkbox. Now when you click the "Execute"-button, the report procedure is executed and the output is translated to SQL.

The SQL-output is put into a new "SQL"-tab, where you can copy it to a text document and send to myDBR support. After this, the support team will be able to execute exactly the same report without your table and data structure.