- We are trying to add the Item UofM to the HITB report
- Create dataset with lookup values (Eg. ItemMaster)
- In field, create expression as follows
=Lookup(HITBItemNumber,HITBItemNumber,ItemMasterBaseUofM, LookupDatasetName)
Example:
=Lookup(Fields!ITEMNMBR.Value,Fields!ITEMNMBR.Value,Fields!BASEUOFM.Value, "ItemMaster")
No comments:
Post a Comment