Object SQL-based Report Template

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.

 add_object_sql-based_report.png

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:

Filter-based Report Template

SQL-Based Report Template

Using the Report Manager