How to: Preload the Cache (Management Studio)

  • Article

To preload the cache with a user-specific report

  1. Create a data-driven subscription for the report as follows. In Object Explorer, expand a report server node.

  2. Expand the Home folder, and navigate to the folder containing the report. Expand the report item. Verify that the report uses stored or no credentials.

  3. Right-click the Subscriptions folder, and click New Data-Driven Subscription. This starts the Data-Driven Subscription Wizard.

  4. In the General Properties page, type a description for the subscription.

  5. Select Null Delivery Provider from the Delivery method list box. Click Next.

  6. In the Delivery Data Source page, click A custom data source..

  7. Click Default to use the default connection string. The default connection string is the one used to connect to the report data source.

  8. Specify the credentials used to access the data. Select an option to use stored or no credentials. Click Next.

  9. In the Delivery Query page, type the query string that you use to retrieve the subscriber list from the external data source in Command text. For example:

    Select * from UserInfo

  10. Click the Validate button. The query must validate before you continue. When the Validation successful message appears, click Next.

  11. In the Extension Settings page, click Next. There are no extension settings for the null delivery provider..

  12. In the Parameter Settings page, configure the report's parameter values. Click Next.

  13. In the Subscription Trigger page, specify when the subscription is processed. Do not choose When the report content is refreshed. 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, select On a custom schedule. Configure the schedule and then click Next.

    Note

    In order for the subscribers to receive the newest report, the report cannot be configured to run as a snapshot. To configure the report to use the most recent data, follow the numbered steps in the next procedure.

To process a report with the most recent data

  1. In Object Explorer, expand a report server node.

  2. Expand the Home folder, and navigate to the folder containing the report you are preloading into the cache.

  3. Right-click the report and then click Properties. The General page of the Report Properties dialog box is displayed.

  4. Click Execution in the Select a page area on the left. The Execution page of the Report Properties dialog box is displayed.

  5. Click Render this report with the most recent data.

  6. Select Do not cache temporary copies of this report, or 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 the report. Expire after minutes. Type the number of minutes for report expiration.
    • To make the cached copy expire on a schedule, click Cache the report. Expire based on the following schedule. Click Report-specific schedule, and then click Configure. After configuring the schedule, click OK.
      Or, to use an existing schedule, click Shared schedule.

  7. Click OK.

See Also

Concepts

Report Caching in Reporting Services
Creating, Modifying, and Deleting Schedules
Shared Schedules and Report-Specific Schedules
Report Server How-to Topics
Pausing and Resuming Shared Schedules

Other Resources

Scheduling Reports and Subscriptions
Using Object Explorer

Help and Information

Getting SQL Server 2005 Assistance