In my SSRS 2008 R2 Pie Chart I want to display 3 values which are calculated fields in my dataset.
The dataset collects a bunch of stats for call center agents. Among them are ProductiveTime, ExcepctionTime, NonProductiveTime, for, of course, a given time period.
If you think you need a bit more details read this paragraph:
The systems keeps track of each change of status in an agent. For example, on break, lunch, in a meeting, training, etc. Then in my stored procedure I create an additional column that has the category of that status, so, for example, lunch, on break will be NonProductiveTime, and so on. Between the selected time period there will be hundreds of entries logging each time there is a change in status, and how long the status lasts.
So back to the Pie, I am adding the SUM of those 3 values to the Chart Data, each one being a series.
The problem I am having, is that when I select the Series Label Properties and configure the format for the Number, only the first series picks it up. It doesn't make a difference if I do it using the UI or the properties window.
What am I doing wrong?
Best Answer
i had this same issue, if you just use the arrows (little blue arrows at the top of the chart data box) to move the value to the top of the list you can edit the label details/code/expression etc for that series. then just repeat this for all the values you've added.
i'm sure there's a better way but this worked so that's what i did. It seems that when you are editing a label it is only ever editing the item/value at the top of the list, after you've done your labels then just shuffle them back into the order you wanted them listed