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):

enter image description here

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:

enter image description here

=iif(fields!outstanding.value=0, "not finished", "late issue") 

this leave 2 series groups late issue , not finished.

let me know if helps.


Comments

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

javascript - jQuery UI Splitter/Resizable for unlimited amount of columns -

javascript - IE9 error '$'is not defined -