Hi all. Maybe you could help me. I'm working in a 3D Bar Chart Report in SSRS 2008 and I've some values equal 0. I would like to show the colored bar for those values but SSRS just show the label value 0, not a 0 bar. I show 2 samples, the first is what I want obtain in SSRS 2008, the second is what I can do actualy. Could you tell me if is there any way to show a bar for 0 value? Thanks a lot.

Could someone tell me something about my question? I'm not able to solve myself. Thank you again. David.

Hi David, I’m afraid it is by design that nothing displayed when values equal 0. One workaround is to display a very short bar (similar to 0) but still with labeled 0 in the corresponding position in chart. Please refer to the steps below: 1. In order to display a short bar, we need to modify the data field bound to the data value in the Chart. For example, if the data value of series in the chart originally is =Sum(Fields!Amount), we need to change it to =IIf(Sum(Fields!Amount.Value)>0,Sum(Fields!Amount.Value),Max(Fields!c2.Value,scopename)/1000) In this expression, please be aware to specify a dataset name or a group name in higher level to the scopename argument. Then we can display a thousandth of the max value for the 0 value bar instead of nothing. 2. In order to still display the correct data label in chart, we also need to bind data field to the data label. Please right click labels in the chart and select Series Label Properties. Then specify the expression like =Sum(Fields!Amount) in the Label data dropdown list. If anything unclear, please feel free to ask. Thanks, Tony Chain Please remember to mark the replies as answers if they help and unmark them if they provide no help

Thank's a lot Tony. I'm very grateful for your answer. David.