SSRS 报告失败，如何确定根本原因？
我有一份报告，本质上是一份采购订单。它包含多个 Tablix 和大约 4-5 个共享数据集。由于某种原因，当我尝试加载特定采购订单的 PO 时，报告会进入循环并一直停留在那里，而报告服务器的内存和 CPU 使用率会急剧上升。
当我从报告中分离出一个 tablix 时（它恰好有一个分组），报告将运行良好，如果我将相同的 tablix 放入报告中，它自己的所有内容也可以正常工作。
任何人都知道为什么会发生这种行为，更重要的是解决这些愚蠢报告的最佳方法是什么？我已经检查了从数据源到物理重建整个报告的所有内容，而我自己和同事完全没有想法。
感谢您提供的一切！
布伦特
I have a report that essentially is a purchase order. It contains multiple tablixs and about 4-5 shared datasets. For some reason when I attempt to load a PO for specific purchase orders the report goes into a loop and just sits there while the report server spirals up in terms of memory and CPU usage.
When I break out one tablix from the report (it happens to have a grouping in it) the report will run fine and if I place that same tablix in a report all it's own it works fine as well.
Anyone have an idea why this behavior is happening and more importantly what's the best way to troubleshoot these stupid reports? I have checked everything from the data source to physically rebuilding the entire report and myself and a colleague are totally out of ideas.
Thanks for whatever you can offer!
Brent
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
看来这个问题在某种程度上与我们的门户网站的 HTML 渲染方面有关。如果您在其他媒体（例如实际的 .NET 表单应用程序）中运行该报表，它会呈现良好的效果。一定是此特定报告的 HTML 生成中的错误。
It appears this problem was somehow related to the HTML rendering aspect through our web portal. If you run the report in other mediums such as an actual .NET forms application it renders fine. Must be a bug in the HTML generation for this specific report.