MSRS 的大型报告
我有一份报告需要能够在 Web 浏览器中呈现大量页面（在本例中约为 4500 个）。对于我正在查看的实例，从开始时间到结束时间在报表服务器上完成所需的总时间约为 30 分钟。有谁知道有哪些选项可以在网络浏览器中处理如此大的报告的呈现？
在研究如何解决这个问题方面，我已经执行了以下任务。该报表从数据库表中获取数据，该表已将数据展平至报表服务器上的 TimeDataRetrieval 为 17812 或大约 18 秒。报表本身已重新格式化，以包含尽可能便宜的报表对象，以便以正确的格式呈现数据。我基本上由一个带有大约 4 个嵌套表的表组成，仅此而已。我们试图在 2005 年的报表服务器上完成此任务，但仍然遇到内存问题，这对于我们的客户来说是不可行的。为此，我们将其移至 2008 年的报表服务器上，以利用它使用文件系统而不是内存的事实，最终能够在不耗尽可用内存的情况下使其正常工作，但当然需要更长的时间。
I have a report that needs to be able to render a very large amount of pages (about 4500 in this instance) in a web browser. The total time needed to finish on the report server from start time to end time is about 30 mins for the instance that I am looking at. Does anyone know what options exist for handling the rendering of such a large report in a web browser?
In terms of looking into how this can be resolved I have already performed the following tasks. The report gets its data off of a database table that already has the data flattened to the point that the TimeDataRetrieval on the report server is 17812 or about 18 secs. The report itself has been reformatted to include the least expensive report objects that it can in order to render the data in the correct format. I basically consists of a table with about 4 nested tables and thats it. We were trying to accomplish this on a 2005 report server but continued to run into memory issues that were not feasible for our clients. In response to that we moved this onto a 2008 report server to take advantage of the fact that it uses the file system instead of memory and finally were able to get this to work without running out of the available memory but of course it takes much longer.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我想说这是不可能的，浏览器无法处理那么多数据。但我发现很难相信有人会发现 4500 页的报告有用。
如果所有页面的数据格式大致相同，则应将其拆分为主子报表样式的报表。有一个几页的主报告，其中充满了其他子报告的链接。
I would say this is impossible, a browser is not ment to handle that amount of data. I find it hard to believe anyone is finding a 4500 page report useful though.
If that data is in approximately the same format for all the pages you should split this up into a master-subreport style report. Have a main report of a couple of pages full of links to the other subreports.
您可以使用任务管理器，在夜间生成报告，因此用户只需下载它，渲染就已经完成了。
You can use the task manager, generate your report during the night, so the user just have to download it, the render have already been done.