December 16, 2007

Configure a Report to be cached (SSRS 2005)




If you have reports which are large in size, accessed frequently and do not display recent data, then the reports qualify to be cached. A cached report is a copy of the processed report which is returned to the user everytime, till the cached copy gets expired. With reports containing parameters, multiple version of the report are cached based on the parameters

To configure a cache, follow these steps :

Step 1: Navigate to the Report Manager (http://localhost/Reports/Pages/) and click on the Contents tab. Here you will see a list of reports installed. For this example, I will use the Northwind reports as shown below. You can use any of the reports you desire to cache.







Step 2: Navigate to the report for which you want to configure the cache options; in our case we will navigate to the Customer report as shown below.










Step 3: Click on the Properties > Execution tab. You will see some options for caching the report as shown below












Step 4: Click on "Cache a temporary copy of the report. Expire copy of report after a number of minutes". Set the minutes to 30.
I would also encourage you to try out the other options on the form.

To read more about caching report, follow this link.


Did you like this post?
kick it on DotNetKicks.com
subscribe via rss subscribe via e-mail
print this post follow me on twitter


About The Author

Suprotim Agarwal, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal

 
  Feedback:

comments

0 Responses to "Configure a Report to be cached (SSRS 2005)"
 

Copyright © 2009-2014 All Rights Reserved for SQLServerCurry.com by Suprotim Agarwal | Terms and Conditions