Mon 8 Dec 2008
SSRS: Disable Reporting Services Cache in Preview Mode
Posted by Ralf under .Net, SQL Server, Uncategorized
[276] Comments
How to disable caching in SQL Server Reporting Services for Visual Studio in Preview Mode?
SQL Server 2005 Service Pack 1 brings a new feature: caching data in BIDS (Business Intelligence Development Studio) Report Designer. Following objects are cached: all the data query, parameter value and credentials for previewing a report. Sometimes this feature can be annoying, if changes in preview mode should be visible immediately.
In order to disable the caching feature, following key has to be added to the config file ‘RSReportDesigner.config‘.
Key:
<Add Key="CacheDataForPreview" value="False" />
Location:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSReportDesigner.config
To clear the cache you can also delete the *.data cache file which is located in the report RDL directory.
SSRS: Caching Files (Preview Mode)
You know, the thing about SQL is, that there is virtually nothing that can replace it.
Does anyone know if a substitute exists for sql? I mean besides MS SQL and Oracle and all that jazz. Thanks.
Thanks, Ralf. This was causing problems for a report that we generate daily; the data wasn’t being updated each day!