June 11, 2014 at 12:29 pm
I'm using SSRS 2008 R2. I have a Shared Dataset that is pulling from a stored proc. When I update the query in the stored proc, SSRS doesn't automatically run the updated version. I'm still getting the old data on the report. If I run the stored proc in Mgmt Studio, I can verify that the data has been updated. But SSRS isn't executing the updated query. I've tried running the report and hitting the refresh button, as well as clicking the Refresh Fields button in the Shared Dataset properties. Nothing seems to work so the report obtains the most recent query results. Any ideas would be helpful. Thanks
June 11, 2014 at 12:31 pm
Go to the folder where the report is stored. There is probably a cached data file with the extension .DATA. Delete that file and try again.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 11, 2014 at 12:51 pm
Thank you, Koen, that worked. However, isn't there a more efficient way to handle incorporating query revisions into the report?
June 11, 2014 at 2:10 pm
fstop (6/11/2014)
Thank you, Koen, that worked. However, isn't there a more efficient way to handle incorporating query revisions into the report?
Not really (although someone made a shortcut: Clear Report Data Caches from Within BIDS). It may seem like a drag, but imagine life without SSRS caching the data. Suppose your stored proc runs for 30 seconds. Each time you want to view the report while designing it, you'd have to wait 30 seconds.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply