问题描述
我正在使用 SSRS 2008 创建报告.是否可以从多个数据源创建报告?
I am using SSRS 2008 to create a report. Is it possible to create a report from multiple data sources?
谢谢.
推荐答案
使用 SQL Server Reporting Services 2008 R2，您可以使用查找函数从第二个数据集中查找一段数据:http://blog.datainspirations.com/2010/03/19/sql-server-2008-r2-reporting-services-look-up-look-down-look-all-around-第一部分/很方便.
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.
在旧版本的 SSRS 中，您可以创建一个占据表格中一个单元格的子报表:可以使用每一行的不同参数调用子报表，从而有效地连接"到第二个数据集.http://technet.microsoft.com/en-us/library/ms160348.aspx
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
这篇关于SSRS 多数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！