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.
How to export SSRS 2008 R2 report(.rdl) to excel with formulas?
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.
Follow
1
Add comment
More
Report
1 Expert Answer
Still looking for help? Get the right answer, fast.
Ask a question for free
Get a free answer to a quick problem.
Most questions answered within 4 hours.
OR
Find an Online Tutor Now
Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.