SSRS Main Dataset data in SubReport

  • 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

  • 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?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply