How To Insert Excel Formula To Cell In Report Builder 3.0?

There is RDL report template for SQL Server Reporting Services. I need to set value for cell in table in the report template which must be calculated from other values in the repor

Solution 1:

Excel Formulas support has ended since SSRS 2008 (see Breaking Changes in SQL Server Reporting Services).

No Formula Support in Excel

In earlier versions of Reporting Services, there was limited support for translating expressions in RDL to Microsoft Excel formulas. In this release, when you export a report to Excel, RDL expressions are not translated to Excel formulas.

If you really need to have the formulas in the excel file and can't use SSRS 2005, you could do the following workaround:

• Append an extra ' before every formula (ex: ="'=C3+B3") in your report
• Open the exported excel file
• Do a find and replace to remove the leading '

But it will not suit every cases...

Solution 2:

It's not possible to export Excel formulas from SQL Server Reporting Services. The only thing you can do is use standard SSRS expressions but these will export as values in Excel (and any other export format.)