Learning Hub..!

Prabhakaran J – Blog

SSRS

Lookup Function in SSRS

In this article we can see how we can pull the data from another Dataset by using Lookup Function in SSRS

Please have look on the datasets. We have one Employee Dataset and another one Employee Salary Dataset. Here we need to join both dataset and need pull the salary from Employee Salary Dataset.

Expression :

Lookup(Fields!Empid.Value,Fields!Empid.Value,Fields!Salary.Value, "ds_Salary")

Result:

Thank You

Leave a Reply

Prabhakaran Jayaraman