I need to print the Country from the Part’s table onto the SOPickList report.
I have managed to bring the Part table onto the Report Data Definition and print the ISOrigCountry field from the Part onto the SOPickList report. However this displays the “country number” not the country name.
So I need to also link the Country table onto the RDD to pull through the country name.
However the Part table’s ISOrigCountry field is a character type and the Country tables’s CountryNum field is an integer. So when I create a relationship under the RDD, I get the following error:
“Task: Parent Columns and Child Columns don't have type-matching columns.”
I have tried creating a calculated field on the RDD Part’s table and setting it to Integer and linking on that, but I do not see how to define the calculated field to hold the Int(Fields!ISOrigCountry.Value).