7

I have a subreport that uses the same data as my main report. Right now, it populates its dataset by re-querying the database.

Is there a way to pass the data set to the subreport instead of creating the dataset again for the sub report,because this will improve the performance of the report.

Can i use shared dataset or the sub report will query the shared the dataset again ??

Sally El-Sayed
  • 161
  • 1
  • 5
  • 11

1 Answers1

5

You should use a shared dataset and set it to cache. Then when the dataset is ran from the sub-report (assuming you use the same parameter values) it won't query the database again.

There is lots of information available regarding dataset caching, its benefits and usage cases.

http://technet.microsoft.com/en-us/library/ee636149.aspx

Sam
  • 7,245
  • 3
  • 25
  • 37