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

Object DataSource Accessed once per table

1 Answer 16 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Kyle Smith
Top achievements
Rank 1
Kyle Smith asked on 24 Jul 2013, 04:29 PM
I am using the latest Q2 2013 release. I am using the Visual Studio report builder.

I have a report that has 3 tables. They're each bound to the same object data source. Each of the three tables is reporting on the same data but in a slightly different way. The problem I have is that the object data source select method is called once per table. This is a problem because the select method is grabbing a RANDOM subset of the available data (the randomness has to exist for proper government reporting requirements). Since the method is called three times, I am getting three different sets of random data. That doesn't work. What I need is the method to be called ONCE and all three tables to reference that set of data. Is there some way I can accomplish this?

Thanks

1 Answer, 1 is accepted

Sort by
0
Kyle Smith
Top achievements
Rank 1
answered on 24 Jul 2013, 08:08 PM
Nevermind--I discovered the Telerik Reporting does not cache the data and therefore I needed to sort of re-think my report setup to allow me to cache the data.

It involved me using NeedDataSource, calling my object data source method, and caching the results. Future calls to needs data source simply returned the cached data.
Tags
General Discussions
Asked by
Kyle Smith
Top achievements
Rank 1
Answers by
Kyle Smith
Top achievements
Rank 1
Share this question
or