Post reply

Reporting Services Color Property

  • July 26, 2009 at 7:45 pm

    #134612

    Hello Everyone. Can someone please help me?

    I have the following expression in the color property:

    IIf(Fields!DocNumbr.Value)=NULL,"Red","Black")

    I also want the field DocuNumbr to say "Invoice Not Raised" when

    the value equals NULL. How do I do that?

    Thanks in advance for your help!!

  • July 27, 2009 at 6:22 am

    #1030452

    Change the expression to read:

    =iif(isnothing(value) = True, "Red","Black")

    the same would hold true for your other value in question.

  • July 27, 2009 at 6:26 am

    #1030453

    Hi,

    Keep the same in color property and change text box Expression as

    IIf(Fields!DocNumbr.Value)=NULL,"Invoice Not Raised",Fields!DocNumbr.Value)

    KSB.

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

  • July 27, 2009 at 4:53 pm

    #1030789

    Thanks very much for your help.

    I was just wondering is the following also acceptable in both the color and value properties:

    =IIf(Fields!DocNumbr.Value = Nothing,"Red","Black")

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

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