HI I have a basic problem but it leads me to ask a few questions. I have an existing report that uses a shared data source pointing at my DEV server. I run this report and get back the values from DEV in my report. Great. I then edit the data source and change it to point at the same DB but on my TEST server. The values on the TEST server DB are different but when I run my report I still get back the DEV values. Now you are goign to say it is cause the data is cached and I need to delete the data file that is stored in C:\MyReport with the .rdl file. I have done this, I still get back the DEV values. If I edit the data set that holds the data and run the SP from there I then get back the TEST values I want. Its like the data source connection is also being cached somewhere. Why is this happening ? So I have searched and read up on this on the net. Have read that the bin directory (C:\MyReport\bin) contains the files that are created when you build your report and are used when you preview the report. These are also the files that get deployed. Is any of this true ? Other questions:- 1) If I delete the files in the bin directory, surely I should just have to build my report and data source again and they will appear there ? Have tried this but it then errors saying it cant find the files in this directory ? 2) What led me to do no 1 above was that when I change my data source and then build it, it says that it is skipping the build cause the data source is up to date? How can it be, I just changed it ? Somehow through deleting the data source file, having SSRS throw an error, closing down VS, restarting it, pasting the data source back into the bin directory, deleting the cached data file and numerous other things I have now gotten the report to run and return the values from TEST. Problem is I have done so much fiddling I dont know what the solution was. Desperate to find someone who can explain all of this properly, or point me to a good article that I cant seem to find. Heeeeeeelp please !!! Thanks G

Hi Gaz…zzz, According to your description, you have changed the data source, but the data values you got still the same as when you got on the DEV server, right? If in this case, have you re-deploy the data source, or have you set “OverwriteDataSources” to True on the properties when you deploy the data source to report server? For more information about deployment, please refer to the following article, How to: Set Deployment Properties (Reporting Services): http://msdn.microsoft.com/en-us/library/ms155802(v=SQL.100).aspx If you have any question, please feel free to ask. Thanks, Eileen

Hi Gaz…zzz, According to your description, you have changed the data source, but the data values you got still the same as when you got on the DEV server, right? If in this case, have you re-deploy the data source, or have you set “OverwriteDataSources” to True on the properties when you deploy the data source to report server? For more information about deployment, please refer to the following article, How to: Set Deployment Properties (Reporting Services): http://msdn.microsoft.com/en-us/library/ms155802(v=SQL.100).aspx If you have any question, please feel free to ask. Thanks, Eileen

Hi Eileen Thanks for your reply and the link, which I have read. My problem is not in deploying the report, I have not even reached that stage. I am still authoring the report and testing the results by previewing it. Changing the connection properties on the data source and then re-previewing the report does not seem to have any effect. This is where my problem lies and hence all my questions. Thanks GGRDixon

Hi , I Think the Report Data is Getting Cached and the Values are Not Changing when you change the Datasource Connection. 1.Try to Clear the Cache in Reportserver Db which has no straight forward Command.So,Download BIDS from this Link. http://bidshelper.codeplex.com/releases/view/67452Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/

Hi Rakesh As mentioned in my origional post, I have deleted the data file (which stores the cached data) with no luck. You seem to be suggesting that the data is ALSO cached in the report server DB? I was not aware this happened, and if it does the report would have to be deployed for it to appear in the report server DB....which mine has not. I am previewing the report on my local machine which does not have reporting services installed, thus I do not have a report server DB. Also, you suggest installing this 3rd party software. I have read up on its functionality to delete the cached data (http://bidshelper.codeplex.com/wikipage?title=Delete%20Dataset%20Cache%20Files&referringTitle=Documentation) and it does what I have mentioned in my first line.....it deletes the data file which is a physical file located on my C drive, not data in the report server DB?! Its pretty straight forward and you dont need 3rd party software to do that although having this option is quicker. Just to make everything clear for anyone else reading this: This report HAS NOT been deployed !! The only place it exists is on my local machine in BIDS. Thanks GGRDixon

Hi I just wanted to update this post as I seem to have found the problem. The BIN fodler does contain your built reports and these are the reports and data sources that will be deployed. They are also the reports and data sources that will be used when you preview the report. Now I was just deleting the report and data souce files out of here and then trying to preview the report assuming it would just rebuild them. You cant do that, you have to delete everything, ie the whole folder, as it contains another file in it which specifies all the objects in that folder. So by deleting just some of the files you are actually just confusing what it thinks is in there. A better way to do this is to right click on the project and click 'Clean'. So, once you have done this, when you then preview your report again it will rebuild all reports and data sources in the BIN folder and they will now be pointing at the correct environment....and thus I get back the data I was expecting. GGRDixon