Use LookupSet to retrieve a set of values from the specified dataset for a name/value pair where there is a 1-to-many relationship. For example, for a customer identifier in a table, you can use LookupSet to retrieve all the associated phone numbers for that customer from a dataset that is not bound to the data region.
What is the use of SSRS?
SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services that create, deploy, and manage mobile and paginated reports.
How do I merge two datasets in SSRS?
If you need to combine the two datasets, the only way is the following :
- Select the main dataset for the tablix.
- use the lookup function values from the second dataset like this.
