September 15, 2011 at 5:24 am
I believe you 100%. I just got no effing idea of what's wrong here.
September 15, 2011 at 5:37 am
It's very strange, if I make any change (that either adding new graph, dataset or making an alteration to the query) the data get loaded completly.
Without that it seems to be stuck with an old copy of the data
September 15, 2011 at 5:42 am
Resender (9/15/2011)
It's very strange, if I make any change (that either adding new graph, dataset or making an alteration to the query) the data get loaded completly.Without that it seems to be stuck with an old copy of the data
In the reports folder (windows explorer). There should be a .rdl for the report definition + 1 file for the data. Try deleting that data file when you are experiencing the issue.
Not pretty but it might work.
I don't know if there's any way to disable data caching inside SSRS
September 15, 2011 at 5:50 am
OK I'll try that tomorrow, the problem I have is that the api of EVE online only allows you to pull data off the server once every 24 hours.
Well that's not 100% true, you can only pull asset data once every 24 hours.
September 16, 2011 at 1:30 am
OK Checked, no update on the data, removed the data files and reloaded the report project data loaded correctly.
September 16, 2011 at 4:55 am
Resender (9/16/2011)
OK Checked, no update on the data, removed the data files and reloaded the report project data loaded correctly.
half good news. At least now you have a way to move forward. :ermm:
September 16, 2011 at 5:01 am
Yes,cause it's a becoming a general problem with the data files not updating.
September 16, 2011 at 5:08 am
Resender (9/16/2011)
Yes,cause it's a becoming a general problem with the data files not updating.
I'd consider calling product support with this. It's free if it's their fault (MS product). If not it's only a couple 100$.
September 17, 2011 at 1:01 am
It happens some time with view; if you are using any view in your report and change it than try [ exec sp_refreshview '<View Name>' ] and run it. It may work for you..
September 17, 2011 at 2:13 am
Sorry for jumping on this a little late, but it happens to me sometimes too. The problem is only with the report preview in Visual Studio, and I think it has something to do with the fact that it caches the data.
Once you deploy the report, you will see the most current information (deployed version of course). I would suggest deploying it, even if you do it locally on your machine to get around this. In my experience, you cannot trust the data shown in the Visual Studio report preview all the time.
September 21, 2011 at 6:50 am
shivendrakumaryadav60 (9/17/2011)
It happens some time with view; if you are using any view in your report and change it than try [ exec sp_refreshview '<View Name>' ] and run it. It may work for you..
Didn't work,unfortunatly.
It's indeed a cache problem, I tried disabling it by changing the config file but no result.
The MS support site is complete useless can't find how to get to the right page.
September 21, 2011 at 8:50 am
I found the following: http://blog.summitcloud.com/2010/05/disable-reporting-services-data-cache-in-development/
Seems like Visual Studio has a config file for the Report Designer. I've made the change on my side, and it seems to be working thus far.
There is also an open connect item on the issue. Please go and vote: https://connect.microsoft.com/SQLServer/feedback/details/522670/ssrs-turn-off-local-data-cache-in-bids
September 21, 2011 at 8:54 am
Martin Schoombee (9/21/2011)
I found the following: http://blog.summitcloud.com/2010/05/disable-reporting-services-data-cache-in-development/Seems like Visual Studio has a config file for the Report Designer. I've made the change on my side, and it seems to be working thus far.
There is also an open connect item on the issue. Please go and vote: https://connect.microsoft.com/SQLServer/feedback/details/522670/ssrs-turn-off-local-data-cache-in-bids
Interesting. I'd raelly love to see something in the Bids general option settings. Makes WAY more sense to see it there too.
September 21, 2011 at 8:58 am
Ninja's_RGR'us (9/21/2011)
Martin Schoombee (9/21/2011)
I found the following: http://blog.summitcloud.com/2010/05/disable-reporting-services-data-cache-in-development/Seems like Visual Studio has a config file for the Report Designer. I've made the change on my side, and it seems to be working thus far.
There is also an open connect item on the issue. Please go and vote: https://connect.microsoft.com/SQLServer/feedback/details/522670/ssrs-turn-off-local-data-cache-in-bids
Interesting. I'd raelly love to see something in the Bids general option settings. Makes WAY more sense to see it there too.
I agree. The cache feature is/was a good idea for the most part, and I can understand why they did it like that...but not having an option to switch it off just make things much more difficult (unnecessarily).
September 22, 2011 at 12:41 am
Found that blog as well & did try that, but it seemed to have no effect so far.
Viewing 15 posts - 16 through 30 (of 33 total)
You must be logged in to reply to this topic. Login to reply