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 Reporting Services 2005? The obvious difference is that Report Builder will be a brand new tool with a steep learning curve, whereas the OfficeWriter Designer leverages the user’s existing knowledge of Excel and Word to design reports. Microsoft’s Report Builder requires .NET and supports only RDL. Because RDL must render to the lowest common denominator between all Reporting Services outputs, Report Builder will produce reports with extremely limited
