The code is:
=IIF(Len(Fields!Academic.Value)> 0, Left(Fields!Academic.Value,InStr(Fields!Academic.Value, "(") - 1), "")
which produces and error.
If I change the code to
=IIF(Len(Fields!Academic.Value)> 0, Fields!Academic.Value, "") there is no error. I want to display only the characters before ")" character if the field has a value otherwise nothing. Seems simple enough but ...
any ideas.