Adding SQL queries to custom reports

You can add a new System Report with an SQL query.

To add an SQL query to a custom report

1. From the menu bar, select Utilities > Report Specs to open the Report Specifications window.
2. Click New.
3. Enter the System, Category, and Title.
4. Click Parameters to open the Detail Report Parameters window.
5. Enter SQLExec/240 in the Control Procedure field.
6. Add GO after your SQL statement.
7. Click OK.