SSRS report page navigation takes a lot of time

• Sachin Vaidya

  Ten Centuries

  Points: 1273

  More actions

  August 2, 2010 at 6:05 am

  #387482

  Hello,

  I have a huge report in SSRS 2005. When I navigate from one page to another, it takes around 2 to 3 minutes. Any pointers on what to check or do to eliminate this issue and do page navigation a bit faster?

  Regards.

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  August 2, 2010 at 6:14 am

  #1200944

  Sachin,

  You have to cache your dataset.

  It's taking long time because the server is actually executing the entire query again and fetching the result...:-):-);-)

  Raunak J

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  August 2, 2010 at 6:15 am

  #1200945

  http://www.sqlservercurry.com/2007/12/configure-report-to-be-cached-ssrs-2005.html

  Raunak J