July 26, 2009 at 7:45 pm
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
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
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
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