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?