11.1. Caching In

One of the best features of Reporting Services is that the data is requeried each time the report is executed. This is shown in Figure 11-1. The user is not viewing information from a static web page that is weeks or months old. Reporting Services reports include data accurate up to the second the report was run.

This feature can also be the source of one of the drawbacks of Reporting Services. The user is required to wait for the data to be requeried each time a report is run.

Figure 11-1. Serving a report without caching

If your query or stored procedure runs quickly, this may not be a problem. However, even fairly quick ...

Get Microsoft SQL Server 2005 Reporting Services, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.