Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Caching Page, Shared Datasets

Caching Page, Shared Datasets (Report Manager)


Use the Caching properties page to set the cache options for a shared dataset.


This feature is not available in every edition of SQL Server. For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2016.

Use the following procedure to navigate to this location in the user interface.

  1. Open Report Manager, and locate the report for which you want to configure shared dataset properties.

  2. Point to the shared dataset, and click the drop-down arrow.

  3. In the drop-down list, click Manage. The General properties page for the report opens.

  4. Click the Caching tab.

Cache shared dataset

Places a temporary copy of the data in a cache when a user first opens a report that uses this shared dataset. Subsequent users who run the report within the caching period receive the cached copy of the data. Caching usually improves performance because the data is returned from the cache instead of running the dataset query again.

Expire the cache after a number of minutes

Specify the number of minutes to save the cached copy of the data. As soon as a temporary copy expires, the data is no longer returned from the cache. The next time a user opens a report that uses this shared dataset, the dataset query runs and the report server places a copy of the refreshed data back in the cache.

Expire the cache on the following schedule

Schedule the time when the cached data is no longer valid and is removed from the cache. The schedule can be a shared schedule or one that is specific for only the current shared dataset.

Dataset-specific schedule

Specify a schedule that is used only by this dataset.

Shared schedule

Specify a schedule that is shared among reports, subscriptions, and other shared datasets.


Save your changes.

Community Additions

© 2015 Microsoft