isnull in SSRS expressions

Question

How to use this formula in ssrs-expression

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

Thanks.

Answer 1

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.