7.3. Data Caching During Preview
You switched between layout and preview a number of times during the development of this report. If you were to look on your SQL Server, however, you would find the rather complex query that provides the data for this report was only executed once. This is because the data returned for the dataset the first time the report was run is stored in a cache file. Any time after that, when the same report is run in the Report Designer with the same query, same parameters, and same data access credentials, the cached data is used.
This data caching helps to make your report development sessions more efficient. Even if you have a report based on a query that takes a fair amount of time to run, you only have to wait for ...
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.
