• It is recommended to use one query using JOINS, but if that is not possible, you can use LOOKUP in SSRS 2008 R2. Lookup is not available in SSRS 2008 or prior versions.

    You can write an expression like:

    =Lookup(Fields!cod.Value, Fields!cod.Value, Fields!prod.Value, "dataset2")