I am trying to add the PartLot table to the ShipHeadShipDtl relationship as the third inner join but I am not able to add it in the rdd. I could add a new dataset but then it doesn’t display it in the ShipHeadShipDtl group in the dataset report. It only shows it as the “First” and need to add another inner join so that it is grouped correctly in the ShipHeadShipDtl relationship so that it pulls in the correct Part Lot Number associated to that Part. Trying to pull in the PartLot.MfgDt.
Basically, how do you add another inner join to a default relationship in the rdd?
Yes, I am using the out of the box Packslip RDD but I need to add the PartLot.MfgDt to the ShipHeadShipDtl data source since that is what is being grouped on in the rdl report. If I bring in the PartLot dataset into the rdl report, I can’t select it under the ShipHeadShipDtl dataset in the rdl report group, it only allows selecting it as a ‘First’ which I do not want since there could be multiple lots for a part. The issue is adding it to the ShipHeadShipDtl dataset in the rdl.
