When you add or edit a report, the Report Manager detail window includes properties for the specific type of report.
All report types include the following toolbar buttons:
· Save and Close: Save changes and close the report.
· Run: Run the report and open the contents of the report in a new window.
· Export...: Export the report to an XML file, which may be later imported on the same or another system.
The following figure shows the detail window for an Object SQL-based Report Template.
Complete the fields according to the descriptions in the following table.
Object
SQL-based Report Template Settings
Field |
Description |
---|---|
Name |
Enter a unique name for the report. |
Max results |
The number of results displayed in the report. The value -1 retrieves unlimited results. |
Item type |
The type of category to build the object SQL-based report on. |
SQL |
The SQL query to be executed. The SQL defined should only return a single column, which is the unique id of an object matching the Item type drop-down menu. |
Report Settings... |
Report generation options. For more information on report settings see Creating Reports. |
Variable Parameters... |
Parameters the user is prompted to provide when running the report. Variable parameters replace question marks in the SQL query, in order. The number of parameters must match the number of question marks in the query. |
See also: