Hi,My problem is:the Dataset in my report doesn't update the fields' values from the database. I refresh the dataset manualy in the SQL Server Business Intelligence Development Studio to see the new values in the report.can anbody help me and giveme an idea how to do that automatically?thx

Hi,Since reporting servcies is based on web services. It won't get the new result till it get refreshed. How often will the data bechanged? You may use report viewer, and set a self refresh time in the web application.Thanks.Yao Jie Tang -Microsoft Online Community

Hi,Or you may use the AutoRefresh property of the report?Hope it will help.Vitchoura

Thanks a lot for your replies,to be more clear:when I call the report from the reportserver, it doesn't get the updated values in the database until I go back to the dataset and click refresh. so the autorefresh property of the report didn't work.thanks,

This only occurs when in BIDS?If so, browse to the folder that contains your RDL files and delete files with the .data extension.Not sure if understood your problem.Vitchoura

You can also download BidsHelper: http://bidshelper.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=9557 It can help you clear out the data that has been cached.So here is a question I have fo you. What do you mean by update the data? Do you mean the query returns different results? Or do you mean that you change the columns in the reports?You might need to look at the report server execution properties of the report and make sure your report isn't cached.--JoshJosh George LiveLogic, LLC

thanks so much Vitchoura,I deleted the .data file and now it's working great:)thanks

hi Josh,I just want you to know that I am new in SSRS and I have never configured the execution properties :(after reading your comment I googled 'how toconfigure the report server execution properties of the report'.first, as I read in the msdn that I have to go to the properties tab and click execution, I didn't find the properties tab in the management studio (FYI, I have SQL server 2005).second, I have read too that I have to connect to the report server, but I didn't find the Object Explorerin the view menu.It would be great if youtell me step by step how to configure the execution properties of the report.thanks for your help,

hey Josh,I solved the problem.thanks,

hey Josh, I solved the problem. thanks, Hey m1m1 , How did you solve the problem? because i'm having the same exact problem!! deleting the .data doesn't help ! Thanks

Never mind, using scheduled snapshots is better than caching, you never know when the cache will take place !

Hi Yousef / M1M1 I have the same Issue , the dataset is not refreshing with Autorefresh both in BIDS and Reporting Server . There is no .data file . In Bids when go back to Design mode and back to review then we are getting the latest data. In Reporting server the data is not refreshing with Auto Refresh , it refreshing only when we refresh IE . How To Solve this Issue . Surendra Thota