Dear All I have a report created where when I run the query in the Data tab, it gives correct results. But, when I go to the preview tab and click on "View Report", I get cached results. This happens also in the Report Manager, it shows only old data. I've tried, -refreshing data -deleting .data files -checked to make sure the caching option is not turned on in Report Manager -Deleting the rdl file and uploading again in Report Manager Nothing seems to work. I always see the same data. How do I get rid of this cache. I use SSRS 2005 and I've never seen this behaviour before. Thanks and Regards SueSue Kailasam

if your query use parameter make sure query refrence to the correct parameter make sure your parameter default valueAhmed Ekdawy

Thanks Ahmed for your reply. Checked the query reference and there are no default values.Sue Kailasam

can you put your query may can help u?Ahmed Ekdawy

Hi SueKailasam, Thanks for your question and Ahmed’s logical reply. According to your description, I understand that the results in Query Designer of the Dataset are correct, however, when you clicking View Report tab or viewing the report in the Report Manager the data region displays the old data. Although you had tried to resolve it in various ways, it still doesn't work fine. Considering the situation, let us have an inference for this issue from the Report Manager level, For the report in the Report Manager displays the old data, the possible reasons may be: 1. The report using the catch data, since you had checked to make sure the catching option is not on, so we can get rid of this reason. 2. The property of Overwritedatasource is false, if so, the Data source in the Report Manager couldn’t refresh when you deploying the embedded Data source to the server, however, you had delete the rdl file in the Report Manager, so we should get rid of it. Previous analysis prove that the issue is not in the Report Manager level, let’s continue to find the reason in the report level in the development environment. For the report in the preview tab displays the old data, the possible reasons may be: 1. The report using the catch data, since you had deleted the .data fields, so we can get rid of this reason. 2. You haven refreshed the Dataset’s data after you modified it, so we should get rid of this reason too. Based on the previous analysis, we should finally fixed position in the data region level. You can drag a new table in the report design surface, then binding the data of the Dataset in it without any filters and groups, if the preview results are same as the results in the Dataset’s Query Designer, we can come to a conclusion: the issue caused by the filters or groups in the data region. The possible reasons may be below, please have a check: 1. There are filters in the data region where displaying the Dataset’s records, for example: on group level, row level, textbox level, and so on. 2. There are groups in the data region where displaying the Dataset’s records. If the issue still exist, please feel free to let me know. Thanks, Sharp Wang Best Regards. Sharp Wang

DEar Sharp Thanks Bunches for your detailed explanation. I was going to add that dummy Table to see if grouping was a problem. But prior to that, I noticed that in the Data tab, when I go to edit the dataset the parameters for the query were hard-coded, meaning instead of having ReportParameters!field etc...it has values. Changing that solved the problem. Thanks and Regards Sue. Sue Kailasam