This is a migrated thread and some comments may be shown as answers.

Trouble creating client-side filter

1 Answer 23 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jacob
Top achievements
Rank 1
Jacob asked on 23 Jan 2018, 10:14 PM

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?

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 29 Jan 2018, 11:15 AM
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
Tags
General Discussions
Asked by
Jacob
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or