We have a report with a multivalue parameter whose record source may include ~32k rows of data. Thanks to virtualization, the user is able to scroll through the entire list selecting as many options as they wish. Unfortunately, if the user selects the "<select all>" option, the application becomes immediately unresponsive, and the only way to continue is to restart the application by performing an end task in the windows task manager.
Questions:
- Is there any way to prevent this hard lockup in the current scenario?
- Is there some way to remove the "<select all>" option, either by default or when the data in the combobox exceeds a threshold?
1 Answer, 1 is accepted
Hello Sam,
I noticed that you were added as a CC of a support ticket raising the same issue. I will copy my reply here for the benefit of our community:
The Report Parameter's area of our viewers is optimized to work with a limited number of values. The reason is that the available parameter values are meant to be easily found and selected by the user. For that reason, we cannot guarantee a smooth user experience with thousands of available values for report parameters.
For such scenarios, we recommend two approaches:
1. You may reduce the values for the report parameter by filtering with cascading parameters. Your invoices may be grouped by certain criteria, and you may introduce 2 or more parameters with a limited number of available values to replace a single one with thousands of values. For example, you may filter the invoices by categories, then by subcategories or clients. This is the approach we recommend as it improves the user experience and reduces the load on the viewer's control, i.e. the dropbox. You may find more details in the following articles:
- How to Cascade Parameters with applied filtering on data source level
- How to Cascade Parameters with applied filtering on Report level
2. You may create your own parameters area outside the viewer. Then, you may pass the values selected by the user to the viewer's ReportSource> Parameters collection.
Regarding your second question, you may remove the "select all" option by modifying the viewer's template XAML file.
Regards,
Todor
Progress Telerik