Display data on a tablix from two datasets in ssrs report by joining on Multi columns-SSRS Interview
Vložit
- čas přidán 7. 09. 2024
- Display data on a tablix from two datasets in ssrs report by joining on Multi columns-SSRS Interview
Blog post link for this video for expressions:
www.techbrother...
Lookup Function can be used in SSRS to join two datasets. Let's say we have two datasets
Dataset1 has column FName and LName.
DataSet2 has FirstName,LastName and Region
We would like to Join FName--FirstName and LName--LastName and would like to display
FName,LName( from Dataset1) and Region from Dataset2, if values of columns match.
Here is syntax for Lookup Function.
LookupSet(source_expression, destination_expression, result_expression, dataset)
As we need to join on 2 columns from each Dataset. We need to concatenate the columns and then use in lookup.
If you don't like to concatenate the fields in expressions you have the option to create Calculated field by using FistName and LastName in each of the Dataset and ful as FullName in Lookup Function.
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
www.techbrother...