I’m running into the exception of not being able to have two relationships for the same child table. I’ve read the other threads and am not quite putting the pieces together. Basically we keep track of what customer belongs to a part. Mainly for drawing and compliance purposes. If the job is MTS…

You are close. If you are using the Customer table that is hanging off of the OrderHed, it would look like this. , T5.WhatIf , T6.Name AS Customer, T6.CustID as CustomerId , T7.OrderNum , T8.CustNum , T8.Customer_CustID as SOCustId , T8.Customer_Name as SOCustName FROM JobHead_" + Parameters!Table…

Steve, I’ve come across this issue myself with customer contacts. Same exact situation. I needed to reference the Customer Contact table with regard to two different parents. My work around was to create a UD column on the OrderHed table and then included that in the RDD / report query. I then crea…

In these situations it is best to use a linked table for one relationship and add the customer table for the other. The Linked tables are a report writer’s best friend.

What is a linked table? That’s what I am not understanding. Too use to writing native SQL.

Epicor builds extra relationships that you can add in as needed. You move a table from Available to Picked and then you can select the fields you want on the second tab. You don’t need to build the relationship as Epicor has already done it in the background. [image]

Cool - found in another thread as well. [image] RDD adding Table ERP 10 I think you have to close it out and open it back up. Not 100% sure though.

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘JobHead’. —> System.Data.SqlClient.SqlException: Invalid object name ‘SOCustomer_e3f63cdc34fd45a89b7abba3337ab8cd’.) So does it dump all data into the Customer table, even though the results …

It dumps it all into the Dataset. Which one is that, the Linked or the added?

Wouldn’t it need both the linked child and the relationship child?

Do you understand how the dataset gets generated for the SSRS report? If not, I can explain it and that may help.

That is exactly what I am hoping to understand.

Double Child on SSRS report

Epicor ERP 10

svannimantyber (Steve van Niman) March 1, 2022, 4:20pm 6

Cool - found in another thread as well.

Topic		Replies	Views
RDD: Multiple relationships to same child table Epicor ERP 10 e10 , ssrs , reports	11	3308	May 27, 2021
Trouble adding table to sub report in Job traveler Epicor ERP 10 e10 , ssrs , reports , rdd , sub-report	29	3463	November 18, 2020
Include a table twice in an RDD Epicor ERP 10 rdd	21	6257	July 3, 2019
RDD - Multiple Parent table join a child table Epicor ERP 10	3	1422	January 10, 2021
Referencing the same table more than once on a report - Help Needed Kinetic ERP customization , ssrs , reports	22	2990	October 25, 2021

Double Child on SSRS report

Related topics