Reporting Services 2005 中未生成带有子报告的报告
这是我第一次尝试使用子报告,我对报告服务的总体经验很少(编辑现有报告,创建一些基本报告)。
我已将子报告添加到现有报告中。单独测试时子报告大约1秒返回。为其提供支持的查询会在 Management Studio 中不到一秒的时间内返回。
在没有子报告组件的情况下,主报告大约需要 2 分钟才能运行。然而,对于子报告,它似乎在 10 多分钟后根本没有返回。
我在这里缺少一些基本的东西吗?
它在 SQL Server 2005 上运行,项目位于 Visual Studio 2005 中。
This is my first attempt at employing sub reports and my overall experience with reporting services is minimal (edits to existing reports, creation of some basic reports).
I have added a sub report to a an existing report. The sub report returns in about 1 second when tested separately. The query that powers it returns in less than a second in Management Studio.
The main report takes about 2 minutes to run without the sub report component. With the sub report however, it does not appear to return at all after more than 10 minutes.
Is there something fundamental I am missing here?
This is running on SQL Server 2005 and the project is in Visual Studio 2005.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
这实际上取决于您对子报表的处理方式。每个子报表就像一个完整的报表请求,因此如果将它们放入表格或列表等重复元素中,您必须小心。如果您这样做,您的报告的性能将随着表格/列表的大小而迅速恶化。
It really depends on what you are doing with the subreports. Each subreport is like a complete report request so you have to be careful if you are putting them in a repeating element like a table or list. If you do the performance of your report will quickly deteriorate with the size of your table/list.