In this video of SSRS Tutorial, We are going to learn how to use Lookup Function in SSRS Report to Join two DataSets. You will learn below items in this video How to create SSRS Report from Scratch How to create Multiple DataSets in SSRS Report How to Join two Datasets in SSRS Report and Display fields on Single Tablix from two Datasets Understand Syntax of Lookup Function in SSRS Report =Lookup(Fields!id.Value,Fields!SalePersonId.Value,Fields!City.Value,"DSET_Sales_2016") Visit our website to check out SSRS Tutorial Step by Step http://www.techbrothersit.com/2015/07/ssrs-video-tutorial.html This video is about Join two data sets in SSRS Joining two datasets to create a single tablix in report How to use multiple datasets in a tablix