how can i use conditional iif combined with split?
i'm trying to get values from check boxes(from sharepoint custom list), the condition is like this :
if the value is null/blank, the return value would be "-"
if the value is not blank, the return value would be the value of the check box field that already splitted from the ";#" character
as you might know, values from check box is written along with ";#" character before and after the value itself.
i tried to use this expression:
=IIF(Fields!Action__For_User_Access_.Value Is Nothing," - ",(Split(Fields!Action__For_User_Access_.Value, ";#")(1)))
the split worked just fine, but the conditional iif didn't work.
can anybody help me?
i used that expression in the calculated field.
btw, i'm using report builder content type from ssrs 2008 r2
thx in advance.
View Complete Post