SSRS , 2 datasets with a common Key ID using a List and Table

Question

I want to have a List of a specific entity with 2 table in it using 2 differents DataSet.

Is there any way to embed 2 table in a list? It seem to not be possible.

DataSet 1 
  LocationID (PKEY)
  Name 
  Address

DataSet 2 
  LocationID (PKEY)
  Employee

DataSet 3 
  LocationID (PKEY)
  Sales

Here is Waht I wanted to do

List with DataSet 1 (LocationID as my Reference Key)<br/>
  Table With DataSet 2 (LocationID as my Reference Key)<br/>
  Table With DataSet 3 (LocationID as my Reference Key)

You can make a subreport with the tables 2 & 3 in it, and put the subreport in the list item, and pass the LocationID from DataSet1 to the subreport. — Tab Alleman
Is there a way to do it other than using a subreport since I will have at least 10 tables. — Jean-Francois

Mahesh Mahesh · Accepted Answer · 2015-01-22T06:10:01

No directly you can not use two datasets on same List or for that matter on Tablix or Matrix control. But there are 2 ways to do what you want to do.

1) As @ Tab Alleman suggested you can use the subreport for other tables and include it in your list

2) If you have the Reference Key in each of your dataset then you can use the LookUp Here is more info.

But using LookUp can get very complicated and I would suggest you to use the SubReport.

SSRS , 2 datasets with a common Key ID using a List and Table

1 Answers