Display data on a tablix from two datasets in ssrs report by joining on Multi columns-SSRS Interview
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:
http://www.techbrothersit.com/2016/01...
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
http://www.techbrothersit.com/
Смотрите видео Display data on a tablix from two datasets in ssrs report by joining on Multi columns-SSRS Interview онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь TechBrothersIT 11 Январь 2016, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 42,036 раз и оно понравилось 117 людям.