isnull in SSRS expressions

3
votes

How to use this formula in ssrs-expression

=NOT(isnull({Command.AAID})) or NOT(isnull({Command.HDomain}))
or NOT(isnull({Command.Adomain}))

Thanks.

2
reporting-servicesssrs-2008ssrs-expression
have you tried isnothing()? - Jonnus

2 Answers

4
votes

I think what you're trying to do is display data based on whether or not a field has data in it or not? You can always use an IIF statement with ISNOTHING. See below for the expression.

=IIf(IsNothing(Field!Whatever),0,Field!Whatever)

If that doesn't answer your question, let me know.

0
votes

So to convert Crystal formula to SSRS-Expression,

You need to write expression like below, 

=IIF(Not(IsNothing(Field!AAID)) OR Not(IsNothing(Field!HDomain)) OR NOt(IsNothing(Field!Adomain)),"TruePart","FalsePart")

This expression will work for you!