 <blockquote> <p>if you executing this query from your SSMS it means this other server is a linked server. then it should be no different to execute it from SSRS. </p> <p>Yes it is right you can only add one server to your data source of your dataset whether its a shared data source or embedded. </p> <p>But for instance if you have a data source pointing to say Server A when you executing queries which will be pulling data from Server A and also from server B you will Use fully Qualified name for the Objects from server B and two part name from server A. </p> <p>something like this ...</p> </blockquote> <pre><code>SELECT * FROM Schema.Table_Name A INNER JOIN [ServerNameB].DataBase.Schema.TableName B ON A.ColumnA = B.ColumnA </code></pre> <p><em>obviously <code>ServerB</code> has to be a <code>Linked Server</code>.</em></p>