# Cant see QuoteMtl.MtlPartNum after adding table to RDD

**URL:** <https://www.epiusers.help/t/cant-see-quotemtl-mtlpartnum-after-adding-table-to-rdd/41471>\
**Category:** Epicor ERP 10\
**Created:** [November 21, 2017, 12:52pm UTC](https://www.epiusers.help/t/cant-see-quotemtl-mtlpartnum-after-adding-table-to-rdd/41471 "2017-11-21T12:52:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![NovoGerry](https://www.epiusers.help/letter_avatar_proxy/v4/letter/n/ccd318/32.png) [@NovoGerry](https://www.epiusers.help/u/NovoGerry)\
**Post date:** [November 21, 2017, 12:52pm UTC](https://www.epiusers.help/t/cant-see-quotemtl-mtlpartnum-after-adding-table-to-rdd/41471/1 "2017-11-21T12:52:05Z")

</div>

Hi,  
We are moving to E10.6 shortly & I am familiarising myself with SSRS. I have copied the original Quote Form RDD and added the QuoteMtl table to it (joining by Company, Quote Number and Quote Line). ‘I have grouped by’ the Quote Line Number, then the MtlSeq Number.  
When I run the report it pulls the parent part etc with the line number, but also against all the MtlSeq numbers, though the MtlParts’ descriptions display ok. In both tables the Part Number is referenced only by ‘PartNum’ & I only see one field called this within the report builder for.  
Can anyone help or advise, please? Thanks, Gerrt

---

<div class="post-metadata">

**Author:** ![asmar](https://www.epiusers.help/user_avatar/www.epiusers.help/asmar/32/4119_2.png) [@asmar](https://www.epiusers.help/u/asmar)\
**Post date:** [November 21, 2017, 4:54pm UTC](https://www.epiusers.help/t/cant-see-quotemtl-mtlpartnum-after-adding-table-to-rdd/41471/2 "2017-11-21T16:54:44Z")

</div>

I assume when you did the join you added the relationship. The relationship type should be OUTPUT ONLY. Another think to mention is that many of the columns listed are for tables already joined to the target data definition. You may not need to join to the table. Check the linked tables tab. Also, when you add a relationship to another table you will need to modify your report SQL.

---

<div class="post-metadata">

**Author:** ![NovoGerry](https://www.epiusers.help/letter_avatar_proxy/v4/letter/n/ccd318/32.png) [@NovoGerry](https://www.epiusers.help/u/NovoGerry)\
**Post date:** [November 23, 2017, 8:37am UTC](https://www.epiusers.help/t/cant-see-quotemtl-mtlpartnum-after-adding-table-to-rdd/41471/3 "2017-11-23T08:37:09Z")

</div>

Hi Asmar,  
Thanks very much for your help. I’ve done everything except the modifying my reports SQL. Can you further advise if I do this within the Data Definition, Styles or SSRS Report Builder?  
Thanks again, Gerry

---

<div class="post-metadata">

**Author:** ![asmar](https://www.epiusers.help/user_avatar/www.epiusers.help/asmar/32/4119_2.png) [@asmar](https://www.epiusers.help/u/asmar)\
**Post date:** [January 12, 2018, 3:50pm UTC](https://www.epiusers.help/t/cant-see-quotemtl-mtlpartnum-after-adding-table-to-rdd/41471/4 "2018-01-12T15:50:18Z")

</div>

Sorry for the very-very late response. The data definition and report style are defined within the Epicor environment. When customizing a existing report make a copy of the DATA DEFINITION AND STYLE.

---

<div class="post-metadata">

**Author:** ![NovoGerry](https://www.epiusers.help/letter_avatar_proxy/v4/letter/n/ccd318/32.png) [@NovoGerry](https://www.epiusers.help/u/NovoGerry)\
**Post date:** [January 12, 2018, 3:59pm UTC](https://www.epiusers.help/t/cant-see-quotemtl-mtlpartnum-after-adding-table-to-rdd/41471/5 "2018-01-12T15:59:55Z")

</div>

Hi – no problems, you pointed me in right direction which was extremely helpful

Thanks again, and best regards,

Gerry

Gerry Fitzpatrick | System Administrator  
n17

Tel: 01355 900100

![](https://epiusers.help/uploads/default/original/2X/0/08510993fd2ac1be3306b30d31248c050332925a.jpg)

![](https://epiusers.help/uploads/default/original/2X/a/aa87d781d4908a0c864c8942099fa6dd1de9bdff.jpg)

---

<div class="post-metadata">

**Author:** ![asmar](https://www.epiusers.help/user_avatar/www.epiusers.help/asmar/32/4119_2.png) [@asmar](https://www.epiusers.help/u/asmar)\
**Post date:** [January 12, 2018, 4:00pm UTC](https://www.epiusers.help/t/cant-see-quotemtl-mtlpartnum-after-adding-table-to-rdd/41471/6 "2018-01-12T16:00:54Z")

</div>

The report SQL can be modified using the report builder. You should create a custom reports folder with dedicated sub-folder for each customized report.

 ![customreports](https://epiusers.help/uploads/default/original/2X/9/95b12a4a5393053d7a4a2b487bac2b269c55b7c9.png)