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…

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.

1 Like

Topic		Replies	Views
RDD: Multiple relationships to same child table Epicor ERP 10 e10 , ssrs , reports	11	2444	May 27, 2021
Trouble adding table to sub report in Job traveler Epicor ERP 10 e10 , ssrs , reports , rdd , sub-report	29	2699	November 18, 2020
Include a table twice in an RDD Epicor ERP 10 rdd	21	4840	July 3, 2019
Referencing the same table more than once on a report - Help Needed Kinetic ERP customization , ssrs , reports	22	2192	October 25, 2021
RDD - OrderHed To Customer Epicor ERP 10	6	729	September 26, 2018

Double Child on SSRS report

Related Topics