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.

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

No comments: