Selecting multiple values in a prompt

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 select only one value check to see if the prompt is used in more than one context.

Procedure

  1. Click the prompt control.
  2. 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.
  3. Click the Pages icon Pages icon, and click a report page.
  4. Click the report object associated with the prompt, from the report object toolbar, click Filters filter icon and then click Edit filters.
  5. Double-click the filter associated with the prompt.
  6. 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.