I suggest to introduce a new Report Parameter and set AvailableValues for each of them. and MultiValue=true. The most efficient way to save bandwidth is to filter data records before they are retrieved by the DataSource component. This is called filtering on the “server side”. To accomplish this you can use parameterized DataSource component for each DataSource component that support this. The next step is to map each DataSource parameter to Report Parameters using expressions
For example, in case of creating a SqlDataSource component, it will create a data source parameter for each query parameter. On step 4 of SqlDataSource wizard, you can set the value of each data source parameter. It is convenient to map the value of data source parameter to the value of report parameter.
You might find helpful checking how SalesByRegionDashboard report is created. The examples are shipped with the installation of Telerik Reporting. For example, C:\Program Files (x86)\Progress\Telerik Reporting <VERSION>\Examples\CSharp\ReportLibrary\Dashboard\SalesByRegionDashboard.cs.
As for the UI of the HTML5 report viewer. you could take advantage of our newly released parameters input flexibility (Release History: Telerik® Reporting R1 2019 (18.104.22.168)). You can just add parameters option to the report viewer's initialization options. For example:
For MVC wrapper of the HTML5 Report viewer, you can refer to How To: Change Parameter Editors Type.
For WebForms wrapper of the HTML5 Report viewer, you can refer to How To: Change Parameter Editors Type.
This would change the default Kendo UI ListView for single and multi-value report parameters to Kendo ComboBox and MultiSelect editors.
singleSelect : telerikReportViewer.ParameterEditorTypes.COMBO_BOX,
// defines the editor type for the single select parameters
//defines the editor type for the multi select parameters
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items