.
...
For more information about SSRS, please refer to this article.
...
OfficeWriter SSRS Integration
...
Components
OfficeWriter fits in with SSRS on two fronts:
- OfficeWriter Renderer: Server-side rendering extensions for Excel and Word
- OfficeWriter Designer: The client-side Add-In for Excel and Word for designing reports for the OfficeWriter rendering extensions
How does the OfficeWriter SSRS Integration Work?
As mentioned earlier, the RDL file contains information about connecting to data sources, queries, as well as report design information. The OfficeWriter Designer adds its own data and design information to the report, which will be used by the OfficeWriter Renderer to export the report.
In particular, the Designer saves a binary copy of the Excel or Word template file to the RDL, in addition to information about binding the report data to that Excel or Word template file.
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.