Report Studio

You can allow users to select more than one value or a range of values in a prompt. For example, you have a prompt for which users must select a product line. You can modify 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.

To Allow Users to Select Multiple Values in a Prompt:

1. Click the prompt control that you want to modify.
2. In the Properties pane, choose whether to allow users to specify more than one value or a range of values:
3. To allow users to specify more than one value, set the Multi-Select property to Yes.
4. To allow users to specify a range of values, set the Range property to Yes.

3. Pause the point on the page explorer button and go to a report page.
4. From the Data menu, click Filters .
   
   If you have more than one query defined in the report, you must first click an object linked to a query. If there is more than one query defined in the report, click an object that is linked to the query you want.
5. Double-click the filter associated with the prompt.
6. Change the operator to one of the following:
7. 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.
8. If you are creating a range prompt, change the operator to in_range.
9. For example, [[Margin] in_range ?Margin? where [Margin] is the name of the data item allows users to specify a margin range.

Related Topics:

• Modifying Prompts—Ways you can modify your prompts.
• Change the Prompt Control Interface—How to change the prompt control interface.
• Specify that a Prompt Requires User Input—How to specify that a prompt is required.
• Specify Default Selections—How to specify the default selections for prompts.
• Create a Cascading Prompt—How to create a cascading prompt.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved