Condiditional Formatting Rows

• danielle476

  SSC Rookie

  Points: 43

  More actions

  December 30, 2010 at 8:00 am

  #243024

  ssrs 2008 r2

  I have a report where we alternate row colors using = IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")

  is there a way to also highlight a specific row when a second condition is met?

  =iif(Fields!unreleaseflag.Value = "1", "Red","White")

  I am not sure if this can be accomplished and if it can, how to combine the two statements.

• Devin Knight

  Old Hand

  Points: 396

  More actions

  December 30, 2010 at 10:45 am

  #1267808

  You could probably do it with a nested iif statement make the false part of that nested iif statement your alternating row color expression.

• bikerdadHLV

  SSCommitted

  Points: 1567

  More actions

  May 10, 2011 at 4:48 pm

  #1322680

  danielle476 (12/30/2010)

  ---

  ssrs 2008 r2

  I have a report where we alternate row colors using = IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")

  is there a way to also highlight a specific row when a second condition is met?

  =iif(Fields!unreleaseflag.Value = "1", "Red","White")

  I am not sure if this can be accomplished and if it can, how to combine the two statements.

  Use a SWITCH statement.

  =SWITCH(Fields!unreleaseflag.Value = "1", "Red",

  RowNumber(Nothing) Mod 2, "Silver",

  1=1, "Transparent")

  SWITCH is ALWAYS a better idea than nested IIFs. The problems with the Nested IIF structure are twofold. 1) They can be a beast to sort out what is happening.

  2) At runtime, the 'puter always evaluates the ENTIRE expression, even if the very first IIF is satisfied.