Prompting for filter values
You can use a parameter to prompt an information object user for a filter value. A parameter enables an information object user to restrict the data rows returned by the information object without having to modify the WHERE clause. For example, for an information object that returns sales data by sales office, instead of creating a filter that returns data for a specific office, you can create a parameter called param_SalesOffice to prompt the user to select an office. The WHERE clause is modified as follows:
WHERE SalesOffice LIKE :param_SalesOffice
You create parameters and define their prompt properties on the Parameters page. Prompt properties include the parameter’s default value, a list of values for the user to choose from, and whether the parameter is required or optional. Parameters appear in the Value drop-down list in Filter Conditions with a : (colon) preceding the parameter name, as shown in Figure 3-38.
Figure 3-38  
Do not use a parameter in a filter condition with the IN operator, for example:
Country IN :param_Country
Actuate SQL parameters can only accept a single value, but the IN operator takes multiple values. Instead, do one of the following for the appropriate column, for example the Country column:
*
*
*

Additional Links:

Copyright Actuate Corporation 2012