How to: Cache a Report (Report Manager)

One way to improve performance is to configure caching properties for a report. When a report is cached, a copy of the rendered report is saved for a short period of time. The first user who requests the report must wait for all processing to complete before viewing the report. Subsequent users who request the report within the caching period can view it right away because processing has already occurred.

There are restrictions on the types of reports that you can cache. For example, a report cannot be cached if report output varies based on the user identity or if data is retrieved using the security token of the user who requests the report. For more information, see Report Caching in Reporting Services.

To schedule the expiration of a cached report

  1. Start Report Manager.

  2. In Report Manager, navigate to the Contents page. Navigate to the report for which you want to set caching properties, and click the report to open it.

  3. Click the Properties tab.

  4. In the left frame, click the Execution tab.

  5. On the page, select Render this report with the most recent data.

  6. Select one of the following two cache options and configure expiration as follows:

    • To configure a cached copy to expire after a particular time period, click Cache a temporary copy of the report. Expire copy of report after a number of minutes. Type the number of minutes for report expiration.

    • To configure a cached copy to expire on a schedule, click Cache a temporary copy of the report. Expire copy of report on the following schedule. Click Configure, or select a shared schedule to control report expiration

  7. Click Apply.