Post reply

Tutorial: Adding Conditional Formatting into Reporting Services

  • September 12, 2008 at 11:24 am

    #871205

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

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

  • 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?

  • March 2, 2009 at 2:06 am

    #951707

    Thanks a lot, this has helped me too 🙂

  • 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

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply