To Show Large Data in SSRS Report

• ashokpothuri123

  SSC Enthusiast

  Points: 143

  More actions

  September 16, 2013 at 1:07 am

  #395487

  Hi,

  i have to show a large amount of data in SSRS report. the report is just a plain Table, and fetches the data from Stored Procedure. the sproc is taking 30 secs to fetch 240000 rows of data from SSMS.

  the SSRS report is taking 6 mim to show this amount of data. can i get this fastened in any wany?. tried the pagination option with no luck.

  any suggestions are highly appreciated. i am Using SSRS 2008.

• Koen Verbeeck

  SSC Guru

  Points: 259125

  More actions

  September 16, 2013 at 3:29 am

  #1650345

  At what rate is the data refreshed?

  If it's only daily, you can run a snapshot early in the morning the generate the report.

  It will take some time to transfer the gigantic report over the network though.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP