In Bids , in preview mode the data is not refreshing with Autorefresh Property and when go back to design and come again to Preview tab then we are getting the Latest data . The same behaviour in Reporting server . The screen is refreshing but its still showing the Old data.Surendra Thota

Hi Surendra_Thota, Thanks for your question. In the inchoate edition of SQL Server, this behavior still exists. For SQL Server 2008 R2, after you changed the data, when you click on the preview tab, the data region refresh automatically without go back to design surface. For this behavior of the early releases, I would recommend you to submit a feedback to Microsoft Connect at this link: https://connect.microsoft.com/SQLServer/Feedback. Every feedback submitted will be evaluated carefully by our engineers. They will let you know their comments further through that portal. It would be great if you can also paste the link to the submitted feedback here, so that other community members can see it as well. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi Sharp Is there any work around to to get the latest data for dataset with Autorefresh only. We need this because our reports will be moineterd on the screen , it should be refreshed for every ! min .Surendra Thota

Hi Surendra, Thanks for your reply. I am sorry for didn’t follow up your question in time due to the unusual alert mail. Actually, BIDS uses a data cache when designing reports to speed up your development and improve design-preview iterations. By default, when you clicked on the Preview tab, the Dataset access the data from this catch file first. So if you don’t want to keep this feature, of course you can turn it off, steps are below: Find your config file that controls the Report Designer in BIDS. For SQL Server 2008 SSRS, this should be: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config Change CacheDataForPreview to “false” , if you want to turn it on, just change CacheDataForPreview to “True” Hope it helps you, if your issue still exists, please feel free to let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.