Trouble creating client-side filter

[Jacob]

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?

[Todor]

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