title: SQL Reporting Services empty string handling
body: <p>I'd like to display a string without the last 2 chars in a text field in Reporting Services 2005 vs2005.
  I tried several ways and if the string is empty or null I get an error:
  rsRuntimeErrorInExpression - The value expression for the textbox contains an error: Argument 'Length' must be greater or equal to zero.</p>
  
  <p>Here are the ways I tried:
  IIF(trim(Fields!kuku.Value) = "","", Left(Fields!kuku.Value, Len(Fields!kuku.Value) - 2))</p>
  
  <p>IIF(IsNothing(Fields!kuku.Value) and Len(Fields!kuku.Value) = 0,"",Left(Fields!kuku.Value, Len(Fields!kuku.Value) - 2))</p>
  
  <p>IIF(IsNothing(Fields!kuku.Value) ,"",Left(Fields!kuku.Value, Len(Fields!kuku.Value) - 2))</p>
  
  <p>IIF(Len(Fields!kuku.Value) = 0,"",Left(Fields!kuku.Value, Len(Fields!kuku.Value) - 2))</p>
  
  <p>Any ideas as to what I'm doing wrong?  Thanks in advance.</p>