Editing with SQL

If you are familiar with Structured Query Language (SQL) and prefer to edit your own query, activate the Custom SQL window and edit the statement directly. Interactive Reporting sends the contents of the Custom SQL window to the server when you click Process.

You can use the Custom SQL window to edit query syntax, or to troubleshoot a query which is not processing correctly. With this function, you can only edit the FROM and TO clauses of the SQL statement.

Tip:	You must leave the Custom SQL window open for Interactive Reporting to use your edited SQL statement when processing the query.

To open the Custom SQL window, select View, then Custom SQL.

You can also type edit directly in the Custom SQL window.

Reset restores the SQL statement contained when the Custom SQL dialog box was opened. Use the Window menu to display or hide the Custom SQL window once it is opened.

To save your edits and close the window, you can click Close or click the checked Custom SQL feature on the View menu.