Home Dashboard Directory Help
Search

SSRS 2008 R2 Databar and Sparline Slow Performance by mike_hofer


Status: 

Closed
 as Won't Fix Help for as Won't Fix


4
0
Sign in
to vote
Type: Bug
ID: 781611
Opened: 3/18/2013 2:04:57 PM
Access Restriction: Public
1
Workaround(s)
view
1
User(s) can reproduce this bug

Description


When running a SSRS Report remotely using a ReportViewer control in ASP.NET the report will take a very long to render the HTML output when you are using a Data Bar or Sparkline and the report has more than 30 records. Placing the chart in a rectangle fixed the issue when running the report locally on the SSRS Server, but it did not fix the issue when running the report remotely. This issue is only when rendering the HTML output, Exporting the report does not appear to have the same performance issue.
Details
Sign in to post a comment.
Posted by Microsoft on 10/17/2013 at 4:55 PM
Hello,
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product (service packs)
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available
Thanks again for reporting the product issue and continued support in improving our product.


Mariusz Cichomski
Posted by addamse on 5/9/2013 at 2:10 PM
I have this issue using SQL 2012 SP1 and report viewer 11.0.0.0. The issue occurs because it appears a separate image request is made for every image by the report viewer. This issue is very limiting and makes the use of sparklines, indicators, or data bars impractical to embed in another application since the loads are so slow in the report viewer.
I found this article which describes the same issue: http://www.sqlchick.com/entries/2011/1/25/whats-up-with-the-slow-ssrs-r2-rendering-in-sharepoint-2010.html
Sign in to post a workaround.
Posted by addamse on 5/10/2013 at 7:00 AM
Setting the SizeToReportContent to false allows the images to be consolidated into one image and the performance improves dramatically. This solved my issue.