SSRS Tutorial Part 125- How to Join Two DataSets in SSRS Report by using Lookup Function

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

  1. How to create SSRS Report from Scratch
  2. How to create Multiple DataSets in SSRS Report
  3. How to Join two Datasets in SSRS Report and Display fields on Single Tablix from two Datasets
  4. Understand Syntax of Lookup Function in SSRS Report

=Lookup(Fields!id.Value,Fields!SalePersonId.Value,Fields!City.Value,"DSET_Sales_2016")



 How to join two DataSets in SSRS Report by using Lookup Function - SQL Server Reporting Services(SSRS) Tutorial