none
Report loading takes long time RRS feed

  • Question

  •  

    One of my report is taking very long time to load(6 minutes). But the sql query is taking only 1 minute. I have only one group in the report, that is for showing the group total. How to identify the problem and solve it?. How to know which part of loading is taking long time?

     

    Thanks

    Tuesday, August 5, 2008 1:49 PM

Answers

  • Consider moving your grouping/aggregation out of SSRS and into the data source.  Generally, data sources like SQL Server can perform these operations more efficiently than SSRS. 

     

    You might also want to reduce the overall # of rows in your report via parameterization. 

    Tuesday, August 5, 2008 4:26 PM
    Moderator

All replies


  • Are you using a reportviewer and web application? Are you certain that the report itself has refreshed with the current dataset -- in other words the SQL query and the query that is executed when you run the report match?

    Tuesday, August 5, 2008 2:16 PM
    Moderator
  • Consider moving your grouping/aggregation out of SSRS and into the data source.  Generally, data sources like SQL Server can perform these operations more efficiently than SSRS. 

     

    You might also want to reduce the overall # of rows in your report via parameterization. 

    Tuesday, August 5, 2008 4:26 PM
    Moderator