We have a report which when exported to excel by our system users has other information added to it - information which can't be created programatically. This data is then summarised and averaged in Excel and rather than have my users creating these formulas each time, i'd like to be able to write the formulas into the report and then when its exported to Excel, they are already in place and ready to use. I can't begin a text box with = though, because Visual Studio will think its trying to calculate something. So how do I do this?

I think You are out of Luck to achieve this . Thanks .Rajkumar Yelugu

As far as i Know Preserving Excel Formulae is Not Supported in RS 2005 and RS 2008Rajkumar Yelugu

Hi Holty, Just like Rejkumar mentioned, currently we might not able to achieve this in Reporting Service, so here I would recommend you to submit a feedback to Microsoft Connect at this link at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects. Regards, Challen Fu

Hi, Formulas can be maintained in Report when exported to excel.. this can be achieved by using ReportItems!Textbox1.value.. table text1 text2 Reportitems!text1.value + Reportitems!text2.value When u export your report to excel... u can see the formula in the text3 cell... Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Formulas can be maintained in Report when exported to excel.. this can be achieved by using ReportItems!Textbox1.value.. table text1 text2 Reportitems!text1.value + Reportitems!text2.value When u export your report to excel... u can see the formula in the text3 cell... Regards, Gayathri devi P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :) I keep seeing this mantra posted throughout the site but it simply doesn't work. Maybe it used to work in 2005, but not in 2008 R2. When you export: =ReportItems!FIELD_1_TEXTFIELD.Value + ReportItems!FIELD_2_TEXTFIELD.Value the cell data in the Excel for that field shows me "3" (which is the calculated sum when FIELD_1=1 and FIELD_2=2). You simply cannot get the report to kick out "=SUM(C3:C4)" to Excel. The closest I've gotten is to have it spit out"\=SUM(C3:C4)" and then I have to remove the leading slash from the formula fields after export.