The spreadsheets that I generate with Microsoft’s standard Excel rendering extension, which is included with Reporting Services (SP1), appear to be a “watered down” version of Excel. Why is this?
“The “out of the box” Microsoft Excel renderer can only produce output that is based on the lowest common denominator between a static file (i.e. HTML or PDF) and an Excel file. This is due to the fact that the Excel features are interpreted from the XML structure of the report which has no facility to store advanced Excel features such as charts, pivot tables, VBA, etc. • How do I guarantee the publishing of full-featured Excel and Word reports? To enjoy dynamic spreadsheets that contain all Excel and Word features when using Reporting Services, end users must employ the OfficeWriter Designer to generate an Excel or a Word “template-behind” and associate it with an RDL published to Reporting Services. The RDL must be exported using the “Excel designed by OfficeWriter” or “Word designed by OfficeWriter” custom extensions provided by OfficeWriter Reporting Services version. • How does the OfficeWriter Designer differ from the design tool, Report Builder, which ships with SQL Server Repo
Related Questions
- The spreadsheets that I generate with Microsoft’s standard Excel rendering extension, which is included with Reporting Services (SP1), appear to be a "watered down" version of Excel. Why is this?
- Can I access the data in my system with standard databases like Microsoft Access or spreadsheets like Excel?
- How Do You Add A Drop Down Box In Excel 2007?
