How to get null values?

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

The problem with ssrs is that all 3 parts of the IIF are calculated BEFORE the iif actually starts.

What do you need to do exactly?

supjo Mr or Mrs. 500 Points: 583 More actions · Answer 2

Ya I figured that out. I tried this expression and it worked:

=iif(LEN(Fields!Weather.Value) = 0,"", LEFT(Fields!Weather.Value, LEN(iif(LEN(Fields!Weather.Value) = 0," ",Fields!Weather.Value))-1))

Thanks for your reply!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Ya, the other solution is to create a little function in the code section. That way you have something reusable.

usually code makes things slower, but for sanity's sake... 😉