I am having a strange problem with a snapshot report that is scheduled through Report Manager and runs once a day at approximately 18:30 each evening.
The report contains a column chart with a textual category, numeric data, and a date series.
Above the chart, is a matrix containing the value of the last bar in each series, and the average value of all bars in the series. Here's a screen capture of what the report looks like:
The problem is that sometimes the matrix is missing. The chart still displays properly and all the data is correct. If I rerun the report manually, and save a new snapshot, the matrix re-appears.
For the past 6 months this report has been running flawlessly. In the past 3 weeks, the problem has occurred twice. I don't know why.
Why would the matrix disappear? What is causing this, and how can I fix it? Any ideas?
I'm using SSRS 2008.
Thanks in advance for any insights.
View Complete Post