Post reply

SSRS change font color in matrix

  • July 14, 2017 at 3:27 am

    #338342

    Hello,

    I want to test value in column :
    if value = "No Full " --> font is red otherwise white
    if value<"date of day - two day" -->font is orange otherwise white

    I have write that : 
    =IIF (Fields!Full.Value = "No Full","Red","white")
    =IIF(DateDiff("d",Fields!Full.Value, Now())>2,"Orange","white")

    But I have this result : always is blank !o you have an idea ?

    Thank you

    Anthony

  • July 14, 2017 at 3:49 am

    #1950883

    You can't put two expressions in a single expression. you'll need to stack your inline Ifs. Something like the following might work (untested):
    =IIF(Fields!Full.Value = "No Full","Red",IIF(DateDiff("d",Fields!Full.Value, Now())>2,"Orange","white"))

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • July 14, 2017 at 4:08 am

    #1950884

    Hi

    thank you,

    it's works for test date but not for test "No Full". "No Full" is always white and not red

    Thank you

    this is the result

  • July 14, 2017 at 4:22 am

    #1950885

    Without having access to your, or sample, data, this will be impossible for me to test.

    Considering that you are doing date Math on the same field that contains a string, this does make me think that the either the value of your field in the screenshot is an expression, or otherwise you're passing a date as a string as well (which has its own complications). One of these reasons will likely be why it's coming out like this.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 4 posts - 1 through 3 (of 3 total)

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