Report Filter With Text

2 posts, 0 answers
  1. Kevin
    Kevin avatar
    4 posts
    Member since:
    Feb 2017

    Posted 31 Jul Link to this post

    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

     

     

  2. Silviya
    Admin
    Silviya avatar
    414 posts

    Posted 05 Aug Link to this post

    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
    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? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top