Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Joining tables from two different data sources.

Author  Topic 

matrosov
Starting Member

4 Posts

Posted - 2010-09-24 : 23:17:36
I have a really stupid question because I'm almost positive that I'm missing something really simple. I am trying to design a report using visual studio. SQL 2008R2 server. I have two tables that need to be joined and a simple query written against them and I am trying to use graphic query designer in the visual studio to accomplish this. My problem is that those two tables reside in two different databases/servers and for the world of me I cannot figure out how to join them in the GUI mode. Is it possible to accomplish in Visual studio?
   

- Advertisement -