isnull in SSRS expressions

reporting-services ssrs-2008 ssrs-expression
user3438498 picture user3438498 · Sep 24, 2015 · Viewed 8.4k times · Source

How to use this formula in ssrs-expression

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

Thanks.

Answer

Philip Herman picture Philip Herman · Sep 25, 2015

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.

Related questions

SSRS Expression: The value expression for textbox has scope parameter that is invalid for aggregate

i'm recieving the following error: Error 1 [rsInvalidAggregateScope] The Value expression for the text box ‘Textbox2’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal …

Read More
How to display yesterdays date in SSRS expression

In one of the column name, I need to display yesterday's date like - September 4,2014 I used DateAdd("d",-1,Today()) function to display,but it is displaying like - 9/4/2014 12:00:00 AM. How can i get the above format like - …

Read More
Show or Hide SSRS column based on specific parameter value

I am having trouble showing/hiding a column based on parameter value chosen. How my report is set up: Parameter: ImportStatus --ImportStatus parameter has three values you can choose from: M, V, E If I choose ImportStatus value = 'M', then …

Read More