Generate report in Excel format with formulas
Hi, I have a report with simple calculations (adds some fields). The report is requested in excel format via Reporting Services WebService. I would like to have the generated excel file to have the formulas, not just the results. I tried to put the formula text in report definition, but it does't work, it appears in excel as text, not as formula. How can I do this? Tks, DD
October 4th, 2010 12:56pm

Hi DevDiver, The default Excel render does not support to convert expressions in the report into excel formulas. Instead, it evaluates it during report processing and export the evaluated expression to Excel cell. Hongye Sun give a detailed information about this topic , you could click this link http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/3ddf11bf-e10f-4a3e-bd6a-d666eacb5ce4 to get a reference. Thanks, Challen Fu
Free Windows Admin Tool Kit Click here and download it now
October 12th, 2010 12:31pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics