Custom Job Traveler Report - Help Needed

Kinetic ERP
,
1

We are trying to add the PartLot.HeatNum to the attached report in the sub-report “Traveler_RawMaterialComponents”. I have added the table using the context listed below. But every time I add anything to this report the subreport just disappears. The subreport doesn’t error or anything.

Can someone please try adding the PartLot table to this report and tell me what results you get?

Custom Report Files:
Traveler_Qty_Titles.rdl (15.6 KB)
Traveler.rdl (474.2 KB)
Traveler_AttributeSetData.rdl (24.5 KB)
Traveler_JobParts.rdl (26.4 KB)
Traveler_ParentAssembly.rdl (21.5 KB)
Traveler_SubComponents.rdl (41.5 KB)
Traveler_Quantities.rdl (13.1 KB)
Traveler_RawMaterialComponents.rdl (114.3 KB)
Traveler_RawMaterialComponents2.rdl (47.6 KB)
Traveler_Shipping_Schedule.rdl (47.7 KB)

RDD:
RDDJobTrav_EANBX.xml (1.4 MB)

Context used for adding Table to SSRS:
LEFT OUTER JOIN PartLot_" + Parameters!TableGuid.Value + " T17
ON T9.[Company] = T17.[Company] AND T9.[PartNum] = T17.[PartNum] AND T9.[LotNum] = T17.[LotNum]

Context for adding field to SSRS:
, T17.HeatNum

2

I am not certain, but I think you need to copy the Job Traveler RDD, add your PartLot table, link it up, and add your part and lot fields. Then create a new report style that references that new data definition.

Then (somehow) get that field into the right rdl. I can get as far as updating the RDD, and report style, but I don’t see how to get the PartLot table to be listed in the RawMaterial file.

Maybe if you do the RDD stuff first, then when you update the ssrs data expression it might work.