Example of Custom Text Field Configuration in a SQL Template
The following steps illustrate the advantage of Custom Text Fields.
In the SQL Template Designer, select the component and click .
In the window, define a field named with a data type of and click .
To use this newly configured Custom Text Field, be sure to select the checkbox.
In the window, enter the following SQL query by typing a partial statement and then double-clicking to select fields:
select * from aps_v_host_volume where host_id > ${freeText1}This query can be constructed by combining typing with double-clicking selections in the window, as shown in the following example. For a complete list of database views and columns, you can access the Database View Help.
See Access Help for Database Views.
Enter a partial query: select * from aps_v_host_volume where
Double-click a field to insert the name into the query.
Type an operator: >
Double-click the freeText1 variable to insert it into the query.
The resulting query will be:
select * from aps_v_host_volume where aps_v_host_volume.host_id > ${freeText1}Click .
In the Formatting window, select all the fields for a table.
Save the report template with a name and a menu group.
Generate the report from this report template and in its Scope Selector window, provide a value for the Host ID field. This value will be passed to the query.
