Limiting Multi-Value Parameter Selections in Bold Reports
Published:
Updated:
Users may need to restrict the number of values that can be selected in a multi-value parameter. Limiting the number of selectable items helps manage query complexity and browser performance when dealing with large datasets. This article explains how to use the dropdownSelectLimit custom attribute to increase or decrease the selection limit, allowing you to customize the user experience based on your specific requirements.
Note: Performance optimization are based on general performance considerations and data volumes.
Applies To
- Product: Bold Reports
- Features: Multi-value parameters
Step-by-Step Instructions
Step 1: Navigate to Custom Attributes
- Click on the grey area outside the designer canvas to ensure the report itself is selected rather than a specific report item like a table or chart.
- In the configuration panel on the right, click the Properties icon (settings icon).
- Scroll down through the Properties pane to find the Miscellaneous section. Locate the Custom Attributes property and click the Set Attributes button.
Step 2: Configure the dropdownSelectLimit Attribute
In the Custom Attributes editor dialog, define the new limit:
- Click Add to create a new attribute field.
- Name: Enter
dropdownSelectLimit - Value: Enter the maximum number of items you want users to select (e.g.,
100,500, or1000+).- Default value:
1000
- Default value:
- Click OK to save the attribute.
Step 3: Preview
Once the attribute is applied, the multi-value parameter dropdown will behave as follows:
- Select All Functionality: When a user clicks Select All, the system will automatically check items only up to the number defined in your
dropdownSelectLimit. - Visual Cues: Any values exceeding the limit will not be selected in the dropdown list.
- User Feedback: If a user attempts to manually select more than the limit, the interface will restrict further selections once the threshold is reached.
Note: You can download the sample report here.