title: ssrs report export to excel (formulas)
body: <p>I have an ssrs report that sums a column for a total, like so:</p>
  
  <pre><code>=Sum(CDEC(Fields!Month01Balance.Value))
  </code></pre>
  
  <p>Now, when exporting to excel this does not export as a formula.  I was told there is a way to do it using the ReportFields collection, however I cannot get that to work.  Does anyone know of a way I can get a total column to export a formula to excel?  I don't know how many rows there will be so I cannot manually reference each ReportField text box.</p>
  
  <p>Thanks for any pointers here!</p>