July 6, 2012 at 9:37 am
Hi Guys.
I am new to BIDS 2008 and Reporting Services.
In BIDS 2008 I have created 2 shared data sources in solution explorer (one for production and one for test). I have also created a shared dataset based on one of these two datasources. This dataset is just a simple count of the number of rows in a table.
I have added a report to my project, added a dataset based on the shared dataset to the report and put the field on to the report. This all works fine and gives me the result that I expect.
Now, when I change the shared dataset to use the other shared data source I expect a different value as there are a different number of rows in the table in the other database but the report still shows the value from the first database. Not what I was expecting.
If some sort of caching is going on, is there a way to force a refresh? Is this a bug or am I mis-understanding the concept of shared datasets and data sources?
Many Thanks
Dave
July 6, 2012 at 11:34 am
This is a "feature". If you look in the report project folder you'll see a file with <name of your report>.rdl.data. Deleting this file will delete your data cache and allow your data values to be refreshed.
I use a plugin called BIDS Helper, http://bidshelper.codeplex.com/. It has an option to delete all of the dataset cache file for the open solution (Right click the solution in the solution explorer window, delete dataset cache files). BIDS Helper does a lot of cool things and I would definitely recommend it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply