Ssrs 2012 subreport is running really slow

[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…