Tutorial: Adding Conditional Formatting into Reporting Services

• jpanzeca

  Grasshopper

  Points: 11

  More actions

  September 12, 2008 at 11:24 am

  #871205

  The following expression has worked for me in a matrix...

  =iif(InScope("matrix1_RowGroup1"), "Transparent", "LightCoral")

• anjik

  Newbie

  Points: 5

  More actions

  October 23, 2008 at 5:11 pm

  #888955

  I am working on a matrix report and would like to have the text shown in Bold AND Red if the number is negative and just plain old black if not.

  Also the field that I want this happen in is a formula so that is causing me some grief.

  =FormatCurrency(Fields!Budget.Value-Sum(Fields!Encumbered.Value))

  So can you show me what the iif statement would look like?

• warren.adams

  Grasshopper

  Points: 11

  More actions

  March 2, 2009 at 2:06 am

  #951707

  Thanks a lot, this has helped me too

• Ammer

  Valued Member

  Points: 65

  More actions

  March 25, 2009 at 10:11 pm

  #966409

  How about if you want to conditionally format rows for a change in a field(rows) values? e.g. for every change in a clientID...alternate the row colour. I've managed to get it partially working...

  i.e. =iif(Previous(Fields!clientID.Value) = Fields!clientID.Value, "Gainsboro", "White")

  Cheers

  A