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: