List parameters

List parameters are used to provide a user that runs a report with a list of values that are contained in a pipe delimited data string. When the report is run, the user must enter a value from the list.

The following example illustrates a list that is used when a report is run.
Select list parameter
This example, demonstrates how to use a pipe delimited data string to create a list with three values: 50000, 75000 and 150000.
List parameter definition

Optionally, a description for each value can be specified by using a colon delimited string. For example, to display Small, Medium, Large to represent values in a list, enter 50000:Small|75000:Medium|150000:Large in the Data field.

Multiselect

Multiselect displays a list of possible values, allowing the user to select more than one value. The selected values are passed to the report as a string in the following format, value 1, value 2, value 3, and so on.

To pass multiselect values in this example, the following sample SQL might be used.

select ae.user_name as "who", (select name from audit_event_definition where 
audit_event_definition.audit_event_definition_id = ae.audit_event_definition_id) 
as "what", (select auditeventdetail(ae.audit_event_id)) as "where", 
aed.event_timestamp as "when" from audit_event_data aed, audit_event ae where 
aed.audit_event_id=ae.audit_event_id 
and ae.audit_event_definition_id=($P!{Audit_Events})order by aed.event_timestamp