How to: Preload the Cache (Report Manager)

Use a data-driven subscription to preload the cache with instances of parameterized reports.

To preload the cache with a user-specific report

  1. In Report Manager, navigate to the Contents page, and then navigate to the report you want to create a subscription for.


    In order to create a data-driven subscription, the report must be configured to use stored credentials or no credentials.

  2. Click the report, click the Subscriptions tab, and then click New Data-Driven Subscription.

  3. Optionally type a description for the subscription.

  4. From the Specify how recipients are notified list, select Null Delivery Provider.

  5. Specify a data source type and then click Next to configure the data source.

  6. Specify the connection type, connection string, and credentials for accessing the data source that contains subscriber data. The following example illustrates a connection string used to connect to a SQL Server database called Subscribers:

    data source=<servername>; initial catalog=Subscribers
  7. Click Next.

  8. Specify the query or command that retrieves subscriber data. Optionally increase the time-out period for queries that take a long time to process. For example:

    Select * from UserInfo
  9. Click Validate. The query must be validated before you continue. When the Query validated successfully message appears, click Next.

  10. Because you cannot configure delivery extension settings for the null delivery provider, click Next.

  11. Specify report parameter values for the subscription, and click Next.

  12. Specify when the subscription is processed. Do not choose When the report data is updated on the report server. That setting is for snapshots only. If want to use a pre-existing schedule, select On a shared schedule.

    Or, to create a custom schedule, click On a schedule created for this subscription and then click Next. Configure the schedule and then click Finish.


    In order for the subscribers to receive the newest report, the schedule that you configure should be consistent with the report delivery schedule that you have defined for the subscribers. For more information, see Report Caching in Reporting Services.

  13. Configure the Execution options for the report as follows. On the report page, click the Properties tab.

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

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

  16. Choose one of the following two cache options and configure the expiration as follows:

    • To make the cached copy 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 make the cached copy 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 set a schedule for report expiration.
  17. Click Apply.

See Also


Creating, Modifying, and Deleting Schedules
Shared Schedules and Report-Specific Schedules
Pausing and Resuming Shared Schedules
Report Manager How-to Topics
Report Manager

Other Resources

Scheduling Reports and Subscriptions

Help and Information

Getting SQL Server 2005 Assistance