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:
see what is causing each applicable subreport to run so slow and/or
What can I do to speed up the applicable subreport(s)?