Unable to export SSRS report to excel with Excel formulas.
Posted on 2016-10-04
I want to generate a report through SSRS with excel formulas ,I was not able to do so.
So, I found an alternative where I can export the report with formulas as text.
Then in the exported excel sheet. I placed the cursor on each cell and presses F2 this turned the exported text to excel formula.
But this method is not feasible in my case since have lots of cells with excel formula.
Please suggest how can this be achieved.
I am using SQL Server (BIDS) 2008R2.
Thanks, for the help in advance.