reporting services - Display only two items in legend -
how go showing 2 items in legend in stacked chart? i've got 2 stacks on each bar, each showing 2 individual items in legend. need 2 of removed.
here picture of how looks (see green box):
i need remove 2 items "0 - outstanding" , "1 - outstanding".
i'm using code display "late issue":
=iif(count(iif(fields!outstanding.value = 1, 1, nothing)) > 0, "late issue", nothing)
and "not finished":
=iif(fields!outstanding.value = 0, "not finished", nothing)
outstanding binary value working boolean value (1 being true , 0 being false).
in series group properties, group on
property use:
=iif(fields!outstanding.value=0, "not finished", "late issue")
this leave 2 series groups late issue
, not finished
.
let me know if helps.
Comments
Post a Comment