.
...
When the report is exported using the Renderer, Reporting Services generates the data sets from the data sources and queries in the RDL. Then the Renderer loads the copy of the Excel or Word template file and binds the data from Reporting Services to the template. The Renderer is actually using ExcelTemplate and WordTemplate to bind the data to produce the output.
| Info |
|---|
If you want to export a report to one of the default rendering extensions, you will need to design a layout for the report in Visual Studio or Report Builder because the report designed in Excel or Word for OfficeWriter will only be available to the OfficeWriter renderer. |
Why use the OfficeWriter Integration?
...
Using the OfficeWriter SSRS Integration allows end-users to Design reports in Excel and Word and make sure of the features in those applications.
| Info |
|---|
If you want to export a report to one of the default rendering extensions, you will need to design a layout for the report in Visual Studio or Report Builder because the report designed in Excel or Word for OfficeWriter will only be available to the OfficeWriter renderer. |
Interested? Learn more about OfficeWriter for SQL Server Reporting Services!