We have recently upgraded one of our servers to SQL Server 2008 r2 Standard Edition (64 Bit). After migrating one particular report to 2008 r2 i noticed that when I toggled in a group to show detail it now takes around 7 seconds to show the detail and if I think toggle another drilldown it takes twice as long to render the page again, adding around an extra 7 second for each toggle. In SSRS 2008 the toggle for all of these is pretty much instant. In each toggle area in the tablix I do have a gauge, when I removed this the problem went away. I also rebuild the report from scratch in SSRS 2008 r2 to see if this may be the issue, and I was confronted with the same problem. I swapped the gauge for a data bar but still the same problem. Rendering this when activating the drilldown toggle and it takes around 7 seconds, and much worse when you drilldown on other toggles. I have applied SP1 for SQL Server 2008 r2 and Cumulative Update 1 for this Service Pack, and nothing fixes this. I have seen a similar issue reported when SSRS is in Sharepoint Integration Mode, however I am running Reporting Services in Native Mode. The issue happens when run remotely and when run on the localhost itself. When opened in Visual Studio the drilldown toggle is instant as it is when deployed to SSRS 2008. My only current fix is to deploy these reports to a server running SSRS 2008, but I am missing out on some nice functionality in SSRS2008 R2!!! Is there a fix for this? This is really holding us back from using SSRS 2008 r2.

Hi GDS_DBA, Is it more specific to some reports or complete SSRS 2008 R2 is slow? If all reports on SSRS 2008 R2 server are slow executed, I suggest you try to disable any of your third party applications/services on this machine and check the behavior. If it is just the report migrated from old release, please take a look at this thread: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5d70f2c2-a84b-4a52-a79c-af1908b4a2f9/. Thanks, Lola Please remember to mark the replies as answers if they help.

Thanks for the reply Lola. The slowness is specific to reports that contain any kind of gauge or databar within a tablix toggle, so when I toggle and drop within a group the breakdown of the group is displayed in the databar or gauge. In SSRS 2008 Report Manager they render in less than a second. In SSRS 2008 r2 Report Manager it takes 7 seconds for one toggle to render and then if I open another toggle it takes 14 seconds and 21 seconds if I open another (see a pattern there?). It looks like it is re-rendinger each detail toggle each time at the same cost in time!!! These were migrated from SSRS 2008. But as I said I recreated the reports from scratch in SSRS 2008 r2 and still the same problem. I take away the gauge or databar from the tablix group and it renders instantly like in SSRS 2008, but obviously this takes away the functionality from the report. I have tested this on two independant servers with the same result. One running a Windows Server 2003 Operating System and one running on a Windows Server 2008 r2 Operating System. This seems like a similar problem:- http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/76665539-9fe6-427d-bb43-7bfd16cbcd3d The poster has said the problem was answered, but if you look into the posts, it wasn't actually fixed properly. Also in this link I can see the poster has similar problems in SharePoint Integration Mode:- http://www.sqlchick.com/entries/2011/1/25/whats-up-with-the-slow-ssrs-r2-rendering-in-sharepoint-2010.html However, I am running in Native Mode. In the link you have provided the answer to the problem is not visible to me....The link to the answer:- http://social.msdn.microsoft.com/Forums/en-GB/sqlkjreportingservices/thread/db837806-eed7-403d-9329-de2ab2c7696a Displays simply "You are not authorized to perform this action." This machine is only running very few applications. It is mainly SQL Server Database Services, SSIS, SSRS and SSAS. However I will run a review and see what can be switched off and test again. However I have already tested rolling back to SSRS 2008 and the reports work fine, even deploying from a desktop with the Client Tools from SSRS 2008 r2, so I still believe this to be a SSRS 2008 r2 bug/problem. Any other ideas anyone? Currently I simply can't upgrade to SSRS 2008r2 until this problem is overcome. Thanks, GDS_DBA

Any ideas on this.....anyone? It's delaying any rollout on SSRS to 2008 r2 because our toggle dashboards are unusable?