Custom SSRS SO Acknowledgement Report taking 2 minutes

Epicor ERP 10
2

based on the fact you don’t event select T1 and t2, I would change it to something like

   erp.OrderRel T3
--LEFT OUTER JOIN ---didn't have rpt labeles when I was testing but change T1 to T3
--    erp.RptLabels_" + Parameters!TableGuid.Value + " T4
--    ON T1.RptLanguageID = T4.RptLanguageID
LEFT OUTER JOIN 
   erp.JobProd T5
   ON T3.Company = T5.Company AND T3.OrderNum = T5.OrderNum and t3.OrderLine = t5.orderline and t3.OrderRelNum = t5.OrderRelNum
LEFT OUTER JOIN 
   erp.JobHead T6
   ON T5.Company = T6.Company AND T5.JobNum = T6.JobNum
LEFT OUTER JOIN 
   erp.JobAsmbl T7
   ON T6.Company = T7.Company AND T6.JobNum = T7.JobNum
LEFT OUTER JOIN 
   erp.SerialNo T8
   ON T7.Company = T8.Company AND T7.JobNum = T8.JobNum and t8.ordernum = t3.ordernum and t8.OrderLine = t3.orderline and t8.OrderRelNum = t3.OrderRelNum

By the way if diesplaying code even aql use the three ticks at the start and end of your code to make a code block refer to here:

1 Like