SSRS – LookUp, MultiLookUp and LookupSet Functions
SSRS gives a lot of features to represent the data into graphical mode to give the clear picture of the business growth. How to implement LookUp function in SSRS report.
These functions play an effect role to link together data from two shared datasets in one data region. SQL Reporting Services comes with three lookup functions having four parameters as given below -
Lookup (source_expression, destination_expression, result_expression, dataset)
LookupSet (source_expression, destination_expression, result_expression, dataset)
MultilookUp (source_expression, destination_expression, result_expression, dataset)
http://www.sql-datatools.com/2015/07/...