Report caching

You can cache a copy of a processed report on the Report Server and serve a cached copy from the server. Since the cached information is retrieved from the temporary location where it was stored the first time it was requested, the turn-around is very fast as no data is queried again. The idea of report caching is very much analogous to Web page caching.

This can be turned on for individual reports by the user. There is a cache lifetime that can be specified as you do not need the same report forever. In addition, it can affect resources. The report cache can also bring in problems of security breaches and to mitigate this, the report should only be available to the user or group that created the cache in the first place. Hence, ...

Get Learning SQL Server Reporting Services 2012 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.