I created our commercial invoice by modifying the standard packing slip. We assign the country of origin on the part master, so I thought I could either join to the Part or ShipCOO table. Both of them result in the report doubling the shipped quantity, even though there is only one line and one country of origin. The RDD offers Part as a pick link for ShipDtl, but it only returns the country number…we want to display the country name.
Duplicate rows in SSRS always seem to be due to duplicate rows in the joined table, but that is not the case here. I am stumped.