Conditional color expression format does not render in browser but ok in SSDT

• sfletcher-933270

  Right there with Babe

  Points: 784

  More actions

  August 6, 2015 at 3:33 am

  #299390

  I have a chart with series that needs conditional colour for three conditions. One condition must be transparent. I have tried the various IFF or SWITCH expressions below and some work fine in SSDT but when I deploy them to the browser the formatting is lost.

  This simple IFF expression works. The series is transparent as required both in SSDT (Visual Studio BIDS) and IE11 and Firefox browsers but I need two other conditions.

  =IIF(Fields!ExhibitionID.Value = -1, "#00ffffff", "Red")

  The expressions below work in SSDT (Visual Studio BIDS) as expected but when deployed to the browser none of this formatting is rendered and all series are in blues even the ‘transparent’ series. No red at all.

  =IIF(Fields!ExhibitionID.Value = -1,"#00ffffff", IIF(Fields!ExhDepartment.Value = 27,"Orange","Red"))

  =Switch(Fields!ExhibitionID.Value

  = -1,"#00ffffff",Fields!ExhDepartment.Value = 27,"Orange",(Fields!ExhDepartment.Value <> 27) AND (Fields!ExhibitionID.Value <> -1),"Red")

  =SWITCH(Fields!ExhibitionID.Value = -1 AND Fields!ExhDepartment.Value <> 27,"#00ffffff",

  Fields!ExhibitionID.Value <> -1 AND Fields!ExhDepartment.Value = 27, "Orange",

  True,"Red"

  )

  I have tried deleting various files RDL and DATA. I have tried uploading the file from report manager in IE and I have tried editing the file in report manager.

  Please help me understand why this does not render like it looks in the development environment.

  (PS I apologise but I have posted similar in the Microsoft social forum but haven't yet had a response)

  kind regards, Sally