I am trying to add the OrderHed.PONum field to the packing slip but running into some issues. I have the field unexcluded from the OrderHed datasource and tried adding the OrderHed as a join in the ShipHeadShipDtl dataset but no dice. Do I need to make a relationship between OrderHed and ShipHead in the RDD to have it show up in SSRS?
The customer PO # is in the base report already. OrderNum_PONum.
5 Likes
You are correct and I feel like a fool, I think its weird that the field comes from the ShipDtl table in the SSRS when it exists in the OrderHed table.
1 Like
FYI - there are often several tables that can be “linked” to a given data source table in a Report Data Definition (RDD). You’ll see those by selecting the table in the RDD and then looking at the Linked Tables tab. This is where you can define other related columns to be pulled into the report (if they weren’t already there). They show up in the dataset with the table name of the data source and then the column name is the combination of the linked column and the column in the picked Links.
3 Likes