SSRS pie-chart custom color

• shanish

  Right there with Babe

  Points: 768

  More actions

  March 21, 2012 at 2:18 am

  #258933

  I have a doubt here,

  I need to show a pie-chart in SSRS, for the student results according to their status(Pass/Fail).......I have only 4 conditions Male-pass,Male-fail,Female-pass,Female-fail,I need to show these things with my own color,

  for this am using the switch condition as

  =Switch(

  ((Fields!Gender.Value = "Male")&(Fields!Status.Value="Pass")), "Blue",

  ((Fields!Gender.Value = "Male")&(Fields!Status.Value="Fail")), "HotPink",

  ((Fields!Gender.Value = "Female")&(Fields!Status.Value="Fail")), "Orange",

  ((Fields!Gender.Value = "Female")&(Fields!Status.Value="Pass")),"LimeGreen" )

  but in the preview it shows only the default color set, not the customized one, can anyone fix this one...thanks in advance

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  March 21, 2012 at 11:38 am

  #1462328

  I would use AND rather than &.

  Also you might want to check your field values for extra spaces maybe they need to be trimmed.

• shanish

  Right there with Babe

  Points: 768

  More actions

  March 21, 2012 at 11:10 pm

  #1462518

  thanks Daniel Bowlin for ur response, I just tried my code again by using the '&', its working now