Home Forums Reporting Services Reporting Services export report to excel and excel should create formula fields for the sum fields of the report RE: export report to excel and excel should create formula fields for the sum fields of the report

  • I don't believe this is possible. It seems like when RS exports the data, it does data only... and sometimes does some interesting things with column spanning cells too. It may be possible to do something clever where the "value" in the reporting services report is the expression you want Excel to evaluate when it's exported, but my guess is that RS would escape the function and you still wouldn't have what you wanted (besides that, the RS report would look funny then). For our reports, I usually export them to Excel, clean them (a little), then put the functions I want in. Once I had it the way I wanted, I used the new Excel file as a template with the formulas at the top and just cut-n-paste the data out of the new exports into the clean sheet. (yes, I should automate it, but it doesn't need to be done very often)

    I know this doesn't help, but at least you know someone looked at your post (better than zero replies?)

    Chad