How to display data on single tablix from two datasets in ssrs report by joining on single column

SSRS Interview Questions and Answers:
How to display data on single tablix from two datasets in ssrs report by joining on single column

We can use the Lookup Function in SSRS Report to join the data from two datasets. There should be at-least one matching column on which we will join the datasets.

Let's say we have DataSet1 with column FName,LName and DataSet2 with columns FirstName and Region.

If we would like to display FName,LName (from DataSet1) along with Region Column from DataSet2. We can use Lookup Function and write our expressions as shown below.

Lookup Function with Parameters

LookupSet(source_expression, destination_expression, result_expression, dataset)

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial

[krismaly]

I enjoyed this video and recommend others

This is an important question for developers.

Thanks for educating the community and appreciate your volunteership.

Thanks a bunch

[atchayaa]

Finally find the treasure awesome explanation

[solomonoldcastle]

Hi, Can you use the join to get the parameter values? I need to join the 2 tables and use a field on one for my available values for a parameter, I am getting error"Variable values cannot be used in aggregate functions" any way around this?

[atchayaa]

Could you please tell me how to design a card view in ssrs

[kpfander]

How do you resolve the problem when second dataset has more rows then the first one ?