How to export SSRS 2008 R2 report(.rdl) to excel with formulas?

Question

I want to export SSRS 2008 R2 report (.rdl) to excel with formulas. Is OfficeWriter API has this feature? If yes, can anyone please help me on this? Thanks in adv.

Answer 1

When you first open the report it will be just plain static values. You can create fields that look like formulas (ie. "=A2+A3") but they will only be recognized by excel as a formula until after it has been edited. You can do this quickly by just pressing F2, then ENTER on each one. or you can paste special something to a range that won't destroy the formulas. For instance you can copy a zero length string and concatenate it to the formulas. This can also be sped up by creating a template ready to read that formula text. So you would export your report, then copy and paste all text at once.