Can a Data Region in SSRS use two different data sets?

Question

Hi All,

 

Question Regarding Data Regions:

I am using SQL Server 2008 R2 . In SSRS report, can a  Table or a Matrix have its fields coming from  two different data sets?

Appreciate your help!!

Thanks!!

 

Answer 1

right click one text in a table ,then chose expression chose datasets,you can see the field in other datasets.

Answer 2

Hi friend,

I have came across similar issue in which I wanted to use 2 data sets in a single tablix.

For such scenario there some functions available in SSRS 2008 which might solve your problem.The menu option where we go for writing expressions, functions like LOOKUP, LOOKUPSET and MULTILOOKUP are present which can be used.

http://technet.microsoft.com/en-us/library/ee210531.aspx

Have a look....they might help you.

Bye NJOY

Answer 3

I am using SQL Server 2008 R2 . In SSRS report, can a  Table or a Matrix have its fields coming from  two different data sets?

In SSRS 2008 R2, yes. Follow this link for step by step instructions -  http://blog.datainspirations.com/2010/03/19/sql-server-2008-r2-reporting-services-look-up-look-down-look-all-around-part-i/

Answer 4

Hi All,

 

Question Regarding Data Regions:

I am using SQL Server 2008 R2 . In SSRS report, can a  Table or a Matrix have its fields coming from  two different data sets?

Appreciate your help!!

Thanks!!

 

No one tablix can be mapped to one dataset ! You will have to use a SubReport , IF you use RS 2008R2 then it would be LookUP() LookUpSet() MultiLookUp() .

---

Rajkumar Yelugu