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 a SQL-based Report Template.
The fields are described below.
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. |
SQL |
The SQL query to be executed. It returns all the column data defined in the SQL. |
Report Settings... |
Report generation options. For more information on report settings see Creating Reports. |
Variable Parameters... |
Dynamic parameters can be added through this option with a name and a type to match with any of the field columns defined in the sql query . The previously added parameters could be viewed and edited. Parameters configured will prompt the user to provide values for them when the report is run and based on that data will be retrieved .The parameter values replace question marks in the SQL query, in order. The number of parameters must match the number of question marks in the query. Note: A sample SQL based report template defined with variable parameters will have the sql query part like "select evt_time from vx_evt where evt_time < (?) ;" |
See also: