title: Zero-pad a number in SSRS
body: <p>I am customizing an SSRS report, using an existing DataSource and DataSet.  I can't edit the DataSet definition (no permissions and I'm not going to get it), so I have to work with the data provided.  My problem is that some of the data is a bit garbled.  I'm attempting to group columns on an "Iteration" text column, but it contains data like:</p>
  
  <pre><code>Iteration 01
  ...
  Iteration 09
  Iteration 1
  Iteration 10
  Iteration 11
  ....
  Pending Scope
  </code></pre>
  
  <p>The "Iteration 1" field is in the middle and is really messing me up.  How can I move this to the beginning of the set, or ideally merge it with Iteration 01?  I can't do it in SQL, and it's not a trivial "number format", so I can't just apply a format to it.  </p>
  
  <p>How can group &amp; display the data above with the numbers properly zero-padded on the left?</p>