Thursday, August 4, 2011

How to delete cached data in SQL Server Reporting Services for Visual Studio in Preview Mode?

In Business Intelligence Development Studio (BIDS) you can build your Reporting Service Reports. The preview mode of the report make use of cached data. The following objects are cached: result sets of your datasets, parameter value and credentials. Sometimes this feature can be annoying, if changes in the preview mode should be visible immediately. The cached data is stored in the report RDL directory with the extension *.Data. Assume you have a report called Dashboard.RDL, in the same directory you will find a file called: Dashboard.RDL.Data

Delete this file and rerun your report. The report is now generated without cached data. After completion of the report a new Dashboard.RDL.Data is created.

1 comment:

Irawan Soetomo said...