How to display data on single tablix from two datasets in SSRS ?
How to display data on single tablix from two datasets in SSRS ?
We can display data on single tablix from two datasets with the help of LOOKUP function.
So if we have two datasets and we need to display on a single tablix then they must have one common column in both
datasets on which we can join.
Syntax : =LookUp(source_expression,destination_expression,result_expression,dataset)
source_expression specify the name or key to lookup
destination_expression specify the name or key to match on
result_expression An expression i.e evaluated for the row in the dataset when source_expression=destination_expression
dataset from which we are adding column.
We can display data on single tablix from two datasets with the help of LOOKUP function.
So if we have two datasets and we need to display on a single tablix then they must have one common column in both
datasets on which we can join.
Syntax : =LookUp(source_expression,destination_expression,result_expression,dataset)
source_expression specify the name or key to lookup
destination_expression specify the name or key to match on
result_expression An expression i.e evaluated for the row in the dataset when source_expression=destination_expression
dataset from which we are adding column.
Comments