LookUp functions can be used to cross reference information across multiple datasets. These expressions cannot be used in the query designer, only in a tablix expression.
For example, let’s say you have two datasets:
Lookup expressions are written with the following syntax:
=LookUp( HomeKey, AwayKey, AwayValue, “AwayDatasetName”)
My expression would be:
=LookUp( Fields!ProductSKU.value, Fields!ProductSKU.value, Fields!ProductCost.value, “Dataset2”)
For more information on this topic: http://technet.microsoft.com/en-us/library/ee210531.aspx
Subscribe to our newsletter Get the latest scoop on retail, right to your inbox!