# SSRS Join Table within DataSet

**URL:** <https://www.epiusers.help/t/ssrs-join-table-within-dataset/45283>\
**Category:** Epicor ERP 10\
**Created:** [June 11, 2018, 3:28pm UTC](https://www.epiusers.help/t/ssrs-join-table-within-dataset/45283 "2018-06-11T15:28:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![changchai](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/f17d59/32.png) [@changchai](https://www.epiusers.help/u/changchai)\
**Post date:** [June 11, 2018, 3:28pm UTC](https://www.epiusers.help/t/ssrs-join-table-within-dataset/45283/1 "2018-06-11T15:28:59Z")

</div>

I am modifying the MethodsMaster SSRS report. I need to link it to the **PartXRefInt** table for internal part cross reference

So I download a copy of the SSRS, and went to edit the dataset. The highlighted yellow is what I added.

 ![image](https://epiusers.help/uploads/default/original/2X/0/090110f554995522aee18fbf9bc49458b9d7a0e8.png)

However, when I add the field **XRefPartNum** to the SSRS report and run it, I get the following error. Is there something I am missing?

 ![image](https://epiusers.help/uploads/default/original/2X/b/b17688728d7acc9a5afbd5658073dafa6c171883.png)

---

<div class="post-metadata">

**Author:** ![Mike](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/58f4c7/32.png) [@Mike](https://www.epiusers.help/u/Mike)\
**Post date:** [June 11, 2018, 3:57pm UTC](https://www.epiusers.help/t/ssrs-join-table-within-dataset/45283/2 "2018-06-11T15:57:01Z")

</div>

Did you update the RDD as well?

---

<div class="post-metadata">

**Author:** ![changchai](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/f17d59/32.png) [@changchai](https://www.epiusers.help/u/changchai)\
**Post date:** [June 11, 2018, 4:01pm UTC](https://www.epiusers.help/t/ssrs-join-table-within-dataset/45283/3 "2018-06-11T16:01:22Z")

</div>

I did not. So I also need to add the table in RDD and do the join?

---

<div class="post-metadata">

**Author:** ![Mario.Cortes](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/eada6e/32.png) [@Mario.Cortes](https://www.epiusers.help/u/Mario.Cortes)\
**Post date:** [June 11, 2018, 4:08pm UTC](https://www.epiusers.help/t/ssrs-join-table-within-dataset/45283/4 "2018-06-11T16:08:25Z")

</div>

Yes, you need to. If the table is not included in the RDD you need to add it and then create a Relationship between the tables.

Regards

---

<div class="post-metadata">

**Author:** ![changchai](https://www.epiusers.help/letter_avatar_proxy/v4/letter/c/f17d59/32.png) [@changchai](https://www.epiusers.help/u/changchai)\
**Post date:** [June 11, 2018, 4:40pm UTC](https://www.epiusers.help/t/ssrs-join-table-within-dataset/45283/5 "2018-06-11T16:40:58Z")

</div>

Thank you. I will do that and update if I run into issues.

Also another question related to this same issue. So the Methods Master, the parent part I want to link to the internal part cross reference (PartXRefInt).

The Methods Master also have a sub report that pulls the materials for the MOMs. I would also like to link to the internal part cross reference (PartXRefInt).

Issue is when I tried to create a relationship in the same RDD for 2 parent table to 1 child table, Epicor does not let me. Is there a way around this? Both the main report and sub report seems to be using the same RDD (MethodsMaster).

![image](https://epiusers.help/uploads/default/original/2X/6/69ac84b7617fc5d42245e06830cf9a8557ad318e.png)