Use Prompt editor to specify a parameter prompt’s properties, including display control type, list of values, and default value. You can specify the parameter values and, if desired, a corresponding set of display values that the users choose. You create a list of values by typing the values or by typing an Actuate SQL query that retrieves the values.
|
The query must retrieve one or two columns from an information object or map, as shown in the following example:
|
The first column contains the parameter values. The second column contains the values that are displayed to the user. The information object or map must reside in the same volume as the IOB from which the user launches Actuate Query. If you use a relative path to reference the information object or map, Actuate Query interprets the path as relative to the IOB from which the user launches Actuate Query. If the information object or map defines a parameter, you must provide a value for the parameter, as shown in the following example:
Information Object Designer does not validate the query. The values returned by the query appear when a user specifies a value for the parameter in Actuate Query or BIRT Studio. The values do not appear, however, when you specify a value for the parameter in Information Object Designer or when a report developer specifies a value for the parameter in a report designer.
