Display All Legend text in SSRS report when legend value is 0(Zero)

0
votes

I am new in SSRS report can any one provide information regarding SSRS Pie chart legend "Display All Legend text in SSRS report when legend value is 0(Zero)"

I set this Expression in Report 

=IIF(Sum(Fields!Delaymonth1_12.Value) = 0, nothing, sum(Fields!Delaymonth1_12.Value))

but My report not display all Legend and I use direct value like 

=Sum(Fields!Delaymonth1_12.Value)

then it's Display 0(Zero) value in Report

Please Check Image : 1st Image Display without Legend and 2nd Image display all legend but display 0(zero)

enter image description here

1
.netreporting-servicesrdlcssrs-2012

1 Answers

1
votes

Right click > Properties on each series on the chart. Then on the legend tab, click the expression button beside the text "Do not show this series in a legend" Then use this expression:

=IIF(Sum(Fields!Delaymonth1_12.Value) = 0, TRUE, FALSE)