May 10, 2012 at 8:29 am
Has anyone had an issue with getting old information when trying to preview your report? My data source is a stored procedure. Often, if I make a change to my stored procedure, then preview my report in the BI Studio, the change does not take effect. However, if i view the report on the report website, the report runs fine, displaying the new data. I have tried refreshing the fields of the data source, but that does not help. Any ideas? thank you.
May 10, 2012 at 8:32 am
It cache's the data in a data file within the solution so it doesnt have to hit the DB every time the report is run in BIDS.
Usually I just delete the data file then it rebuilds the data, unsure if there is an option to switch this behavour off though.
May 10, 2012 at 8:34 am
anthony.green (5/10/2012)
It cache's the data in a data file within the solution so it doesnt have to hit the DB every time the report is run in BIDS.Usually I just delete the data file then it rebuilds the data, unsure if there is an option to switch this behavour off though.
Ok thanks. Where is the data file stored?
May 10, 2012 at 8:37 am
anthony.green (5/10/2012)
It cache's the data in a data file within the solution so it doesnt have to hit the DB every time the report is run in BIDS.Usually I just delete the data file then it rebuilds the data, unsure if there is an option to switch this behavour off though.
So if my report name is abc, is it the abc.rdl.data file located where the report is stored? thanks.
May 10, 2012 at 8:41 am
yes it is the rdl.data file.
I have just done a google as I thought best see if it can be turned off and it can.
32bit computer
C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\rsreportdesigner.config
64bit computer
C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\rsreportdesigner.config
And change
<Add Key="CacheDataForPreview" Value="true" />
to
<Add Key="CacheDataForPreview" Value="false" />
May 10, 2012 at 8:46 am
great! thanks for your help.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply