SSRS isnothing working on a whole, but there are insances where it is not picking up everything

Question

I have an expressoin that works on a whole which is:

=IIF((IsNothing(Fields!Hello.Value),".",Fields!Hello.Value)

The only problem is that I have instances where it does not catch every blank. I have thought of using the "LTrinm" within the main statement. Any help would be appriciated.

Thanks,

http://stackoverflow.com/questions/12738569/how-to-check-if-ssrs-textbox-is-empty — majjam, Jan 06 '14 at 14:22
I have double checked and there are fields which apear blank but do have something in the field thanks to @bamie9l expression. — Tito Paterson, Jan 06 '14 at 14:33

score 5 · Accepted Answer · answered Jan 06 '14 at 15:29

IsNothing() checks if a value is null however, you are searching for a blank string. Strings which are "" or " " are not evaluated as null in IsNothing() and therefore are not caught - they have a value of empty or white space.

    =IIF(LEN(Trim(Fields!Hello.Value)) = 0,".",Fields!Hello.Value)

Sidenote: This is why in the .Net CLR there is a method for both IsNullOrEmpty() and IsNullOrWhiteSpace().

SSRS isnothing working on a whole, but there are insances where it is not picking up everything

1 Answers1