Using two datasets of similar data from two sources in one tablix in SSRS

Question

I have two data sources from two different servers that are returning the exact same data. I need to be able to join the two sets of data so I can use them in one query for a single tablix. Can someone point me in the right direction I can take to accomplish this task?

Thanks,
Jeff

Answer 1

Hi Jeff

You can not join the two datasets, but can diplay merged data in tablix by using Lookup / LookupSet functions.

Thanks - Srini.

Answer 2

Thanks Srini,

I looked into those options, however my understanding is to make those work I need for a key to be present in both tables. The issue with this data is that each source is unique. If my understanding is not correct please let me know. I will try to outline a part of my data below maybe that will help.

Datasource 1
select app_num, calls_handled from ds1

This will get me data like:
77   5
82   25
102  13

Datasource 2

select app_num, calls_handled from ds2

This will get me data like:
624  100
625  100

I need the data to be like this:
77   5
82   25
102   13
624   100
625   100

Thanks - Jeff

Answer 3

Hi Jeff,

Sorry I misunderstood the requirement. Good option is to have database links and resolve the issue at database. If you don't have this option available, then may be you can explore using data processing extension to read data from .Net dataset.

http://msdn.microsoft.com/en-us/library/ms152816.aspx

Thanks - Srini.