How to prevent selecting the "<select all>" option from locking up the application

1 Answer 46 Views
Report Parameters Report Viewer - WPF
Sam
Top achievements
Rank 1
Sam asked on 07 Feb 2022, 05:15 PM

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:

  1. Is there any way to prevent this hard lockup in the current scenario?
  2. 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

Sort by
0
Todor
Telerik team
answered on 10 Feb 2022, 02:59 PM

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:

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

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
Report Parameters Report Viewer - WPF
Asked by
Sam
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or