Hello! I have a report that takes almost 20 minutes to be generated. What i want to do, is to generate the report to html and show it in a browser, so that the user can see it, before he generates it to another format. If i want to generate it again to pdf(for example), the rendering will take again 20 minutes?? Or the report that will be rendered, is the one in the cache of reporting services? Is that a way that the conversions after the first conversion to html, can be made faster? I don't want to wait 20 minutes each time i want to convert the report to another format! If someone could help me, i would be thankful!! PS: sorry for the poor english!

Hi, Can you try by keeping different types of formating/rendering based on the "Report Level Parameter", I think in that based on the user has selected the parameter, report will try to execute based on that condition only, which might be one way? Just a hunch. Thanks KumarKG

Hi NBIIS, If the report is not a on-demand report(means the data in the report is not updated frequently), we can use the Cache or Snapshot feature in the SQL Server Reporting Services(SSRS) to enhance the performance. A report server can cache a copy of a processed report and return that copy when a user opens the report. To a user, the only evidence available to indicate the report is a cached copy is the date and time that the report ran. If the date or time is not current and the report is not a snapshot, the report was retrieved from cache. A report snapshot is a report that contains layout information and query results that were retrieved at a specific point in time. Additionally, I would suggest you modifying the query statement to enhance the performance. This should be the best option to reduce the time used to render the report. For more information, please see: Caching Reports (SSRS): http://msdn.microsoft.com/en-us/library/ms155927.aspx Snapshot Reports: http://msdn.microsoft.com/en-us/library/bb630404.aspx#Snapshot If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT