Search code examples
sql-serverreporting-servicesssrs-2008

SSRS multiple data sources

I am using SSRS 2008 to create a report. Is it possible to create a report from multiple data sources?

Thanks.

Solution

  • With SQL Server Reporting Services 2008 R2 you can use the lookup functions to lookup a piece of data from a second dataset: http://blog.datainspirations.com/2010/03/19/sql-server-2008-r2-reporting-services-look-up-look-down-look-all-around-part-i/ Very handy.

    From older versions of SSRS, you can create a subreport that occupies a cell in a table: the subreport can be called with a different parameter for every row, effectively "joining" to the second dataset. http://technet.microsoft.com/en-us/library/ms160348.aspx