Report Filter With Text

[Kevin]

Hi, 

I use html reporting and I need to have a filter like this in photo attached, where I can filter through a text. How can I do this from designer?

 

Best regards

 

 

[Silviya]

Hi Kevin,

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 (13.0.19.116)). You can just add parameters option to the report viewer's initialization options. For example:

$("#reportViewer1").telerik_ReportViewer({
   ...
    parameters: {
        editors: {
          singleSelect : telerikReportViewer.ParameterEditorTypes.COMBO_BOX, //  defines the editor type for the single select parameters
          multiSelect: telerikReportViewer.ParameterEditorTypes.COMBO_BOX, //defines the editor type for the multi select parameters
        }
    }
});

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.

Best Regards,
Silviya
Progress Telerik