SSRS Data Cache in Development
22-Jan-1212 Leave a comment
After some effort I found that data in SSRS Development environment was being cached in a files called <ReportName>.rdl.data
So you may be expecting data to change and finding that it is not. To get around this you can do one of the following:
- Manually delete the <ReportName>.rdl.data each time the data changes
- Right-click the report and press Run
- Use the Run button. The start up item is set in the project properties.
- Following article suggests developers may pull their hair out if they do not realise that data is cached. I did!
http://blog.summitcloud.com/2010/05/disable-reporting-services-data-cache-in-development/
This did not work for me. May be it takes a while for it to settle in? - Microsoft pages are:
http://msdn.microsoft.com/en-us/library/ms157366.aspx
http://msdn.microsoft.com/en-us/library/ms160346.aspx
The following error may be due to this cache of data
[rsInvalidExpressionDataType] The Value expression used in textrun ‘InvoiceTitle.Paragraphs[0].TextRuns[0]’ returned a data type that is not valid.
Good luck!