O'Reilly logo

Learning SQL Server Reporting Services 2012 by Jayaram Krishnaswamy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required