# Custom SSRS SO Acknowledgement Report taking 2 minutes

**URL:** <https://www.epiusers.help/t/custom-ssrs-so-acknowledgement-report-taking-2-minutes/122901>\
**Category:** Epicor ERP 10\
**Tags:** ssrs\
**Created:** [February 4, 2025, 11:33am UTC](https://www.epiusers.help/t/custom-ssrs-so-acknowledgement-report-taking-2-minutes/122901 "2025-02-04T11:33:41Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Hally](https://www.epiusers.help/user_avatar/www.epiusers.help/hally/32/1263_2.png) [@Hally](https://www.epiusers.help/u/Hally)\
**Post date:** [February 4, 2025, 12:01pm UTC](https://www.epiusers.help/t/custom-ssrs-so-acknowledgement-report-taking-2-minutes/122901/2 "2025-02-04T12:01:18Z")

</div>

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

```FROM
   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:

> [@Formatting Code block](https://www.epiusers.help/t/formatting-code-block/52608):
>
> For all of you that are confused about formatting code blocks and other types of markup that can be done on this forum, please look at this link and walk through the tutorial. It does a really nice job of introducing you to how you can format your posts. I know I am a bit OCD about this stuff, but it really does make everything easier to read. [https://commonmark.org/help/](https://commonmark.org/help/)

---

_[View the full topic](https://www.epiusers.help/t/custom-ssrs-so-acknowledgement-report-taking-2-minutes/122901)._