Trouble creating client-side filter

2 posts, 0 answers
  1. Jacob
    Jacob avatar
    3 posts
    Member since:
    Jan 2018

    Posted 23 Jan 2018 Link to this post

    Here is our scenario:

     - We have a report .trdp that the HTML5 viewer requests

     - The report data source is an ObjectDatasource with a single method GetData(ParamType1 Param1, ParamType2 Param2, etc.)

     - When we view a report in the HTML5 viewer, our GetData method gets hit many times.  The data should only need to be retrieved once.

     - We think part of the problem is that we have Report Parameters where the AvailableValues are set the the ReportResults ObjectDataSource.

     - After hours of investigation we have not found how to fetch the data once, and use that data to populate the report DataItems and Parameter Filter Values.

     

    Consider this data set: 

    { createdBy: "McKay", result: "Satisfactory", team: "Pacific" },

    { createdBy: "Johnny", result: "Satisfactory", team: "Arctic"},

    { createdBy: "McKay", result: "Unsatisfactory", team: "Antarctic"}

     

    Our rendered report shows all of the above data items,

    And the filter section next to the rendered report shows all permutations of the parameters based on our data source: 

     

    CreatedBy:

        McKay

        Johnny

    Result:

        Satisfactory

        Unsatisfactory

    Team:

        Pacific

        Arctic

        Antarctic

     

    Is there a way we can achieve this same result without hitting the database more than once?

  2. Todor
    Admin
    Todor avatar
    321 posts

    Posted 29 Jan 2018 Link to this post

    Hi Jacob,

    We have answered the question in the support ticket you opened on the topic (ID 1150350).
    We would continue our communication there.

    Regards,
    Todor
    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