0

I want to export SSRS 2008 R2 report (.rdl) to excel with formulas. Is OfficeWriter API has this feature? If yes, can anyone please help me on this?

Thanks in adv. Mohan.

Sambath Kumar S
  • 407
  • 5
  • 12
Mohan
  • 13
  • 2

1 Answers1

0

Is is possible with OfficeWriter. I would take a look at their documents located at

Sam Plus Plus
  • 4,381
  • 2
  • 21
  • 43
  • Yes, thank you Sam. i started working on that already hope i can achieve this ... – Mohan Nov 10 '17 at 11:46
  • Hi Sam, i tried to add a custom extension and its showing in report manager service in the export options as "Excel designed by OfficeWriter" but when i selected that option i am getting the error as "Error SA008050: This report was not designed for the selected OfficeWriter rendering extension" – Mohan Nov 13 '17 at 08:24
  • Mohan, You would have to create your report with the OfficeWriter designer as the expection indicates. The OfficeWriter designer report does not convert reports it is its own reporting platform. – Sam Plus Plus Nov 13 '17 at 19:07
  • It worked like a magic Sam, thank you very much. Also, i want to change the extension display name but after include the below code in RsReportServer.config file and when i tried to restart the Reporting service its giving an error like "the reporting service is started and stopped ...", what i missed here? My Extension – Mohan Nov 15 '17 at 12:43
  • Oops sorry the XML tag was not closed properly so i couldn't change the extension display name, now its working good. Thanks once again Sam :) – Mohan Nov 15 '17 at 14:23