title: SSRS Report builder LENGTH expression & size specific field
body: <p>I'm trying to build a bank file using SSRS report builder (3.0). I'm running into two issues:</p>
  
  <ol>
  <li>I'm trying to get a length expression to work on a check number field but <code>LEN(Field)</code> doesn't work (returns 4 as the value regardless of the actual length of the field). </li>
  </ol>
  
  <p>And <code>LENGTH(Field)</code> gives me an error:</p>
  
  <blockquote>
    <p>The Value expression for the textrun 'Textbox15.Paragraphs[0]. TextRuns[0\' contains an error: [BC30451] Name 'LENGTH' is not declared*</p>
  </blockquote>
  
  <ol start="2">
  <li>The only reason why I'm even trying to get #1 to work is because I need to have one of the fields on the bank file have a constant length. Regardless of the check number, I need to make sure this field is always at 14 characters with leading zeros. I thought the best way to do this is to do a switch statement and add the number of appropriate zeros in depending on the size of the check number field.</li>
  </ol>
  
  <p>Thanks for the help.</p>
  
  <p>Edit: using a SQL server DB</p>