I'm using SQL 2008R2/Server 2008R2 with Report Manager running reports against an SSAS cube. Typical scenerio: I find some bad data in the cube. I cull the data from my warehouse and process the cube. When I run the report that had the bad data, it STILL SHOWS the previous data set, including the bad data I eliminated. I hit refresh which doesn't refresh. The only way I've found to force a refresh is to go up and change a parameter and hit View Report, then change the parameter back. This seems stupid. Is there an easier way to: 1) tellwhen a report is showing cached data? 2) force a refresh? Thanks.

Hi There If you would like to permanently disable cache from your development environment Find the RSReportDesigner.config file that controls the Report Designer in BIDS. For SQL Server 2005 SSRS, this is normally be: C:\Program Files \Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config Find the RSReportDesigner.config file that controls the Report Designer in BIDS. For SQL Server 2008 SSRS, this is normally be: C:\Program Files \Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config Then please change CacheDataForPreview to false. CacheDataForPreview to false If you have any questions please ask. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

I'm not sure I want to permantly disable caching but I will probably have to if the users are confused. I'm curious why the refresh button does not seem to refresh the report from new data. What is it good for???? It would be nice to have a button on the screen to allow users to choose when they needed to refresh the data. Thanks for the information!

Hi There Thanks for your posting again. If you do not want to change the cache permanently then you could do the following as when we preview a report, the data for the report is cached to a file on the local computer. When we preview the same report report Designer retrieves the cached copy rather than rerunning the query. The data file is saved as <reportname>.rdl.data in the same directory as the report definition file. In normal situation, the cached file doesnt work once we modify the query. At this time, I still suggest that you delete the cached .rdl.data file and then check the issue again. If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi There My apology, I was thinking that you are talking about BIDS cache, please try this Go to Processing Options Properties Page (Report Manager). To open the Processing Options properties page Open Report Manager, and locate the report for which you want to set processing properties. Hover over the report, and click the drop-down arrow. In the drop-down menu, click Manage. This opens the General properties page for the report. Select the Processing Options tab. Here in options choose 'Do not cache temporary copies of this report'. and try to run the report again. If you have any question please let me know Many thanks Syed Qazafi Anjum

Actually I wanted to control caching in both places. I looked and "do not cache" is already set in Report Manager....so maybe it's just inside BIDS & I can control that manaully if I have to. Thanks.