O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

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

Cached reports

Let's set up caching for the sales commission report. What caching does, it allows Report Manager to run the SQL query one time and store the data for subsequent use. The length of time the data is stored is based on the length of time set in the properties. Parameter changes will also affect the length of time the query remains cached. This is why we made the SalesPersonID a report parameter and not a parameter in the stored procedure.

Let's set the cache properties so that the data will be available for half an hour after the data is requested. This will provide enough time for all the reports to be generated for our data driven subscription that we will set up later. First, we need to specify that we want to use caching:

  1. Hover ...

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