Hi, I have a report which contains a chart and the performance to render is very slow. The CPU on the server will max out when it is running. Here is an example of the chart (it is not the simplest graph because the user requires a scatter chart)... This is being run via the report manager, I've tried different browsers (makes no difference). Here are the stats from the executionlog3... On its own the chart would be ok around a 1 minute to execute but it is part of a subreport and called 10 times within the report. The SQL query returns in under 1 second, I'm just not sure why the rendering is taking so long. Any help appreciated Jason

Jase, If the chart is rendered in 1 minute, the calling it 10 times in the subreport would take the report 10 minutes to render. To improve the performance, you should change the report design. You can use caching to cache your report so it will get rendered faster.

I've tried the various different caching options and nothing seems to be a making any difference. The bulk of the time is rending the scatter graph i.e. the "dots". The graph is in theory one graph layered over another graph, I don't really know any other way to get the same affect. So you have a typical timeline as the line graph and then a count per day that is represented by the scatter graph.

Hi Jase, Caching is a performance-enhancement technique. The contents of the cache are volatile and can change as reports are added, replaced, or removed. Here has a blog about the performance of caching, please see: http://blogs.technet.com/b/rob/archive/2010/02/11/caching-ssrs-reports-for-performance.aspx Hope this helps. Regards, Charlie Liao TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here. Charlie Liao TechNet Community Support