In SSRS 2005, when I export data to excel, I am preserving the formula. I use reportItems!ColC.Value ='reportItems!ColA.Value + reportItems!ColB.Value' In excel file I can see that ColC = ColA+ColB eg in excel file sheet A B C 1 ColA ColB ColC 2 7 2 9 3 6 1 7 4 5 0 5 When I click in cell(C2) which has value '9' In the formula field I get the value "= _10 + _11" But In the formula field I wants the value as "= A2 + B2" Similarly cell(C3) which has value '7', I get the value "= _15 + _16" But In the formula field I wants the value as "= A3 + B3"

Hi KeshX, According to your description, you would like to show excel cell name as report item name, right? If I misunderstand, please let me know. I am afraid this behavior you have mentioned is by design at present. There was limited support for translating expressions in RDL to Microsoft Excel formulas. However, since SSRS 2008, RDL expressions are not translated to excel formulas, which is documented at http://msdn.microsoft.com/en-us/library/ms143380(v=SQL.100).aspx by Microsoft. Moreover, if you have any concern about this, please submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope Microsoft improve this feature in the next service pack or product release. Thanks for your understanding. Thanks, Eileen

Eileen, Thanks for you reply. 1) I am using SSRS-2005 and not SSRS-2008 2) In SSRS 2005, as you know, formulas are preserved in Excel export(which is not my issue). But, in the formula field in Excel, I dont see formula with Excel-cell Names but i see formula with cell Names given by SSRS example......... consider a sheet in excel Value of Cell A1 = 2 Value of Cell B1 = 3 if,Value of Cell C1 = A1 + B1 = 5 The formula field of C1 will show as "=A1 + B1" Where A1 and B1 are excel Cell Names . If the same sheet is exported from SSRS-2005 to excel, then Value Cell A1 will be 2 Value Cell B1 will be 3 if,Cell C1 will be 5 (which is sum of A1 and A2), but in the formula field of C1, instead of the formula "=A1 + B1" is see the following formula "= _10 + _11" where "_10" is name given by SSRS-2005 to cell A1 , and "_11" is name given by SSRS-2005 to cell B1 What is need is, after SSRS-2205 to excel export, the formula field should preserve the Excel cell names.

Hi KeshX, Thanks for the clarification. I fully understand the situation and your requirement regarding the feature. However, the translation of the fomular between SSRS 2005 and Excel was limited supported. And the behavior that you mentioned cannot be achieved in SSRS 2005 and later version. If you need that feature to be improved, please submit a feedback at http://connect.microsoft.com/SQLServer/Feedback. Hope Microsoft will re-add this feature and improve it in the next service pack or product release. Thanks, Eileen