You can create a prompt in which a user can select more than one value. For example, you
have a prompt to select a product line. You can set the prompt so that users can select more than
one product line.
If you enable multiple selections, the Auto-submit property is always set to no.
Note: If you have a prompt that is used in both a single value context and a multi-value context,
the most restrictive context (usually the single value context) takes precedence. If you run into a
problem where you have a multi-value prompt but can only select one value, then check to see if the
prompt is used in more than one context.
Procedure
- Click the prompt control.
- In the Properties pane, choose whether
to allow users to specify more than one value or a range of values:
- To allow users to specify more than one value, set the Multi-select property to Yes.
- To allow users to specify a range of values, set the Range property
to Yes.
-
Click the Pages icon , and click a report page.
-
Click the report object associated with the prompt, from the report object toolbar, click
Filters
and then click Edit filters.
- Double-click the filter associated with the prompt.
- Change the operator to one of the following:
- If you are creating a multi-select prompt, change the operator
to
in
.For example, [Product_line] in ?Product
line? where [Product_Line] is the name of the data item allows users
to select multiple product lines.
- If you are creating a range prompt, change the operator to
in_range
.For example, [Margin] in_range ?Margin? where [Margin] is the name of the data item allows users to specify a margin range.