Ssrs 2012 subreport is running really slow

[jassie1]

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

[yosiasz]

Is it related to this post?

Ssrs 2012 performance

This is embedded sql. Here is the sql: --debug --DECLARE @endYear SMALLINT = 2017 --DECLARE @calID INT =5 --DECLARE @report VARCHAR(7) = 'subrpt6' --DECLARE @Sort TINYINT = 1 -- 1 = Last Name, First Name 2 = HM, Last Name, First Name 3 = HM Teacher, Last Name, First Name 4 = Grade, Last Name, First Name --DECLARE @filterByGrade TINYINT = 0 -- 1 = Yes, 0 = No --DECLARE @grade CHAR(2) = '00' --DECLARE @filterBySort TINYINT = 0 -- 1 = Yes, 0 = No --DECLARE @sortFilter VARCHAR(30) = '1…

[jassie1]

yes it is.