Reporting Services – Combining different datasets to be displayed in a single table in SSRS

Regardless of version of SSRS (2005 or 2008), it is not possible to combine different datasets e.g. SQL Server database dataset, SSAS cube dataset, and XML feed. Possible workaround Some ways to achieve this would be to do this in the database during the data source retrieval. Use Linked Servers/CLR Routines/OPENROWSET/OPENDATASOURCE options to combine the…

2