2008 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 Std 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?
If you encounter the same problem, please vote this bug report up, or if you know the answer, please let me know. Thanks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s