开发者

SSRS Report Fails, How do you determine root cause?

开发者 https://www.devze.com 2023-03-06 09:33 出处:网络
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

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 开发者_JAVA技巧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


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消