July 7, 2012 at 9:40 pm
I've actually had this happen a couple of times...
I had a report containing data that wasn't up to date. I checked everything, including opening the report itself and checking in Preview. I finally executed the SQL directly in the query view of the dataset. The updated data came through. When I clicked Preview, the updated data was showing. Has anyone else run into this? If so, do you have any suggestions?
July 9, 2012 at 2:55 am
When you develop a report in BIDS it cache's the data of the initial run.
If you go into the solution folder you will see a number of rdl.cache or cache.rdl files (cant remember which way round they are), if you delete them it will recache the data again.
Edit
Files are rdl.data files
July 9, 2012 at 7:38 am
In addition to deleting the cached data file, if your report has parameters for the end-user to select, you should be able to refresh the cache by selecting different parameters while in BIDS.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply