Jim Mackenzie (2/23/2015)

---

Hi PWalter,

Yes you can create a query based on two different servers, here's some info on how to set it up:

https://msdn.microsoft.com/en-GB/library/ff772782.aspx

Your query would end up looking something like this:

SELECT a.Column1, a.Column2, b.Column1, b.Column2

FROM ServerA.DatabaseA.SchemaA.TableA a

INNER JOIN ServerB.DatabaseB.SchemaB.TableB b ON a.Column1 = b.Column1

WHERE ......

The other thing you could do is create two data sets in your report, one from Server A and one from Server B. Then you could use a LOOKUP to link the two sets together. This may be your only option if your DBAs won't let you link servers. Here's some info:

https://msdn.microsoft.com/en-us/library/ee210531.aspx