It took me a while to figure out - how to use NULL in the Expression Editor. I tried NULL and got the error stating that NULL is not supported anymore, thus System.DBNull should be used.
I tried to use System.DBNull and parser was returning - "DBNull is a type in System and cannot be used as an expression." So much for clearity!
It turned out that 'nothing' should be used instead of null, whenever NULL value needs to be assigned, like in my case:
=IIf(Parameters!FILTER_POA.Value = "NONE", 3, nothing)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment