We have the need to join multiple data sources into one table in SSRS. At present, as I understand it, this is not a part of current delivered functionality. We get around it by creating links withing the source database to access other databases.
The links themselves have their own set of constraints and performance issues.
The other option is to use sub reports.
It would be nice to be able to define connections to disparate databases to join data from multiple data sources. Does Microsoft have plans to deliver such functionality in an upcoming release of the SSRS product?
View Complete Post