Lookup Function (Show 2 DataSets on 1 Table)
Syntax =Lookup(Obj1, Obj2, Obj3, Obj4) Obj1 = Field name on main dataset for join to detail dataset Obj2 = Field name on detail dataset for join to main dataset Obj3 = Field name on detail dataset for show Obj4 = Dataset name of detail dataset Example Dataset1(emp_id, score) Dataset2(emp_id, emp_name) =Lookup(Fields!emp_id.value, Fields!emp_id.value, Fields!emp_name.value, "Dataset2")