I made some changes to my query that is the dataset for a report. The data did not change when I previewed the report. So I made a couple of changes to the report and it still didn't change anything. I can understand caching data to make things more efficient but shouldn't a report writer drop the cache when the source query changes? How can I test a report if the preview doesn't refresh when I make changes to the report or data source? Is there a way to clear this cache before I preview the report?

Hi There Is your query returning the results properly? I mean when you click on dataset and go to query designer and run the query from there. Does it return the results as expected? If your query is returning the results properly and you are using parameters please go to the parameter and go to advance and select always refresh the data. If nothing work for you please try to close the project and reopen that and see if it make any difference 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.

I was running the report over and over with the same parameters since I had specific test data I was looking for, but after tweaking my query (an SP in the database) I was still getting the old data. If I run the query in the visual studio report development enviroment I would get the new values but in the preview of the report I was getting the cached values. Sorry this report is not really high on my priority list so I am not monitoring this thread closely.

Hi, Have you tried to remove your data files files from your target folder ? Hope this will help you !!! Sanjeewan

Hi, Have tried to remove your .rds file from your target folder ? Hope this will help you !!! Sanjeewan

Hi John, From your description, do you mean that the report data were not updated when previewing the report in Report Designer in Business Intelligence Development Studio (BIDS)? I have tested the issue in my local environment, however, the report data were updated properly after altering the stored procedure. 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 again using the same query, parameters, and credentials, 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. Reference: Report Designer-Preview http://msdn.microsoft.com/en-us/library/ms156280.aspx#bkmk_Preview Hope this helps. Regards, Mike Yin

It is unfortunate there is no "drop cache" button in Report Designer, but changing the value of a parameter will force BIDS to invalidate the current cache.The Data Specialist (Blog)