How can I export a report services report to Excel using inline calculations in excel columns?

Question

I want the user to be able to export the report service report to Excel. I have a question, how do I specify a formula in the reporting service that will then be presented as an Excel column in the exported file?

Currently, all I can export is the final results of the Reporting Services report, but I need the user to be able to manipulate the column in the Excel output and see dynamic results. Obviously, they could constantly add Excel formulas after each export, but I would rather automate the whole process.

Thanks,

Brian.

Answer 1

The formulas used in ReportViewer are automatically converted when rendering in Excel. You can also use OmitFormulas using DeviceInfo, if required, during the rendering process.

For more information on how the conversion occurs, check out http://msdn.microsoft.com/en-us/library/aa178946(SQL.80).aspx