Hi,
Related to this thread, which contains a query that I don’t think I’ll be able to fix, how does one join a new table to a definition that has no visible tables? We would like to add customer PO and order numbers to the commission report, but it seems Epicor makes this a complicated task with the way the RDD’s have no tables shown. Thanks in advance.
Make a copy of the RDD.
Then in the new RDD you should be able to add the tables from the New button in the upper left. Add the InvcHead table and under relationships create these links and you should be able the fields you need.
Thank you, Chris. For future reference, how did you determine what fields are available for relationship joins on a ‘table’ like TmpReport? By looking at the associated .rdl? In hindsight it seems obvious the invoice number was included in the dataset, but not seeing any actual tables threw me off.
I probably saw it on here or something very similar and put it into the test system to see what would happen. For the report you will need to add the T2 relationships below
=“SELECT T1.RptLanguageID,T1.CommableHedAmt,T1.CommisErnd,T1.CommissionPercent,T1.Company,T1.custName,T1.HedRate,T1.InvcDate,T1.InvNum,T1.InvTot,T1.LegalNum,T1.RepName,T1.TotCommis,T1.TotHedCommis,T1.Type,T1.Calc_CurrentRate
,T2.InvoiceNum,T2.OrderNum,T2.PONum FROM TmpReport_” + Parameters!TableGuid.Value + " T1 LEFT OUTER JOIN InvcHead_" + Parameters!TableGuid.Value + " T2 ON T1.Company = T2.Company AND T1.InvNum = T2.InvoiceNum"
Yes sir, working on the rdl dataset now, thank you much!
