R2 Report Pagination
I thought it was all too good to be true. We upgraded our reporting server in place from 2005 Std to 2008 R2 and we've hit a major problem. We have a few reports that are about 60 pages. On 2005 the report would render page 1 of 60 pretty quickly. Now it produces page 1 of 2 that is miles long and takes minutes to render. If you have enough RAM and CPU power in your PC to cope. My dev machine can handle it but the average user's machine just dies. There's a brief spike on the server and then it's all your PC that's doing the work. Seeing as I'm the only person who can run these reports at the moment, guess what I've been spending half my time doing?
I've put it up on Connect here: https://connect.microsoft.com/SQLServer/feedback/details/572160/wrong-pagination-in-report-manager?wa=wsignin1.0
If you encounter the same problem, please vote this bug report up, or if you know the answer, please let me know. Thanks.