August 29, 2014 at 9:16 am
Hi
I have a SSRS report (2008 R2) in which multiple sub-reports attached. Main Report dataset is also used in the Subreport. Means Same dataset executing multiple times.
Is there any way to pass MainReport Dataset into SubReport. So that I can improve the performance of the report.
I cant use Shared Dataset, as in RDL we have expression based connection string which is not supported by Shared DataSource
--
Thanks
Jayanta Sarkar
August 29, 2014 at 9:59 am
There's no way I know of to natively share the results of a dataset between reports. I'd question the architecture that requires sub-reports that re-use data in the main report to begin with. Why can't you accomplish the same thing with multiple data regions instead of sub reports?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply