To Show Large Data in SSRS Report

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply