I am modifying a copy of the Packslip SSRS form. I want to add the Country of Origin from Part Maintenance to each line item. I went into Report Data Definition, made a copy of PackSlip and from the Part table, I did the exclusion with CountryNumDescription, ISOrigCountry, and ISOrigCountryNum. I saved the data definition, went to Report Style Maintenance and copied the Packslip report and change data definition to the new data definition where added those 3 fields. Finally did a “Sync Dataset” and downloaded to my desktop to work on.
The issue is I don’t see those 3 fields showing up in my Part dataset in SSRS. Am I doing something wrong? I know there’s the ShipCOO dataset, but this seems to be Country of Origin at the shipping entry level. I want to pull the COO for each part since we have different COO for each part at the line level. Any ideas?