Multiple Data Sources in a Single Data Set

Within "Report Designer", is there a way to query multiple Data Sources within a single Data Set query? I need to build a query in a Data Set that joins three tables from different Servers & Databases. From what I can tell, each Data Set query can only access a single Data Source.better you create a stored procedure in the backend . where stored procedure can interact with differenct databases and you will get your dataset.