Query not updating? (or possibly looking at old data?)

  • 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?

  • 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

  • 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