Example of a Combo Box Configuration in a SQL Template
Create a Custom Combo Box to enable the user to select all hosts for a particular Make:
This Combo Box can be used in a report template query, such as:
select * from apt_v_server where apt_v_server.make = '${freeCombo1}'Note:
Report designer variables are listed at the bottom right of the dialog window. Double-click a freeCombo variable to insert it into the query. If the ${freeCombo1} value is a string, it must be enclosed in single quotes to be evaluated as a text field, as shown in the above example. To determine if a database view field is a string or numeric, refer to the Database Views Help.
Format this report as a table.
Save it as in a Menu Group.
Generate a report from this newly saved report template.
In this example, a Combo Box heading was specified with a list of values that will be presented in a drop-down list in the scope selector, when the user generates the report:
Select a from the drop-down list and click .
