SSRS Job Traveler Mass Print Timeout

[hkeric.wci (Haso Keric)]

@joegollakner did you ever resolve? We upgraded from 10.1.500 to 10.2.300 - same Issue only during Multi-Job Select, do we see some ridiculous exeuction times.

It might be the LEFT JOINS… What does one do hmm…

JobHead LEFT OUTER JOIN JobMtl drastically slows down Job Traveler Report

Hi, I’m trying to customize the Job Traveler report in SSRS and after syncing my copied base report with my duplicate JobTrav RDD, I noticed that the query line “LEFT OUTER JOIN JobMtl_” + Parameters!TableGuid.Value + " T7 ON T1.[Company] = T7.[Company] AND T1.[JobNum] = T7.[JobNum]" drastically reduced the speed of the report performance. Once I take out this query line the report performance is superb. The issue is I need some fields from this JOIN query line. Can you help direct me on a pos…