Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Extremely slow report rendering in SSRS 2008 R2 in Internet Explorer 8 Expand / Collapse
Author
Message
Posted Tuesday, April 12, 2011 2:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 20, 2011 12:01 PM
Points: 1, Visits: 5
Hi- Your problem is that on your report there is a setting that says "Keep together" if possible on your table and/or page. Uncheck that option and it will render to multiple pages. Also check for that setting at the group break level. -DG
Post #1092441
Posted Thursday, February 07, 2013 10:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 18, 2013 11:40 AM
Points: 4, Visits: 99
Refer to this article on Parameter Sniffing. I encountered the same problem and utilized Option 2 and the problem was resolved.

http://www.simple-talk.com/sql/t-sql-programming/parameter-sniffing/
Post #1417244
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse