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.
Open Report Manager, and locate the report for which you want to configure shared dataset properties.
Point to the shared dataset, and click the drop-down arrow.
In the drop-down list, click Manage. The General properties page for the report opens.
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.