January 15, 2013 at 8:53 pm
I have main report and subreport that is called from the main report. Subreport can be called multiple times depending on how many users the report is generated for, therefore I was thinking to use shared datasets to reduce the number of database calls.
The shared datasets are working fine as far as I am not passing UserID into the subreport (which I want to use to filter the output), otherwise the query is called more than once. I can't use page breaks as the report has quite specific layout and the output has to be broken down per user.
So in short the question is: what should I do to to ensure that the query in shared dataset is called just once?
Many thanks
January 16, 2013 at 1:33 am
You could cache the shared data set, that way when the subreport runs it runs against the cache instead of the database for each user.
Might not be feasible if the report is looking at real time data.
January 16, 2013 at 1:35 am
I believe you can just set the caching timeout and it should work. http://prologika.com/CS/blogs/blog/archive/2009/11/16/shared-datasets.aspx
Or you could you use a temp table and base it on that, instead of having a shared dataset?
January 16, 2013 at 11:21 pm
Temp tables are probably more correct solution, but in my case caching is definitely making the trick. Thanks 🙂
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply