SQLTeam.com | Weblogs | Forums

Ssrs 2012 subreport is running really slow

I have an existing ssrs 2012 report that is running really slow this year. Last year it did not run as slow.

Basically there is a driver report and this driver report can run up to 9 subreports. The number of subreports that are executed depend upon how many reports the user selects to run.

Today I ran timings on each subreport and they took between 3 to 5 minutes for each subreport to render when only 24 customers were selected at a time.

Thus is there a way to:

  1. see what is causing each applicable subreport to run so slow and/or

  2. What can I do to speed up the applicable subreport(s)?

Is it related to this post?

yes it is.