You are currently reviewing an older revision of this page.
1. Once you have a query that defines the data fields that you want to pull from the database, Select Manage > *Template Management > Report Template Designer.
2. In the Report Template Designer select File > New.
3. In the New Report Template dialog, select the radio button for Customized by SQL statement, and paste in your custom SQL statement.
4. Click OK.
Then you can start creating the template for your desired report using the data fields specified by your custom SQL statement.
Report Template Designer