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