Message-ID: <1699165747.7745.1711620060385.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7744_1704084077.1711620060385" ------=_Part_7744_1704084077.1711620060385 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The RDL contains information about the data sources, data sets, queries,= connection strings and more. It also contains information about the look a= nd feel of the report. Reports are typically designed in Visual Studio or w= ith Report Builder.
For more information about SSRS, please refer to this MSDN article.
OfficeWriter fits into SSRS with two parts:
Component | Description |
---|---|
OfficeWriter Renderer |
|
OfficeWriter Designer |
|
The RDL file contains information about connecting to data sources, quer= ies, as well as report design information. The OfficeWriter Designe= r adds its own data and design information to the report, whi= ch will be used by the OfficeWriter Renderer to expor= t the report. The Designer sections off a part of the RDL for storing this = information separately from the rest of the RDL file. In particular, the De= signer saves a binary copy of the Excel or Word template file to the RDL an= d information about binding the report data to that Excel or Word template = file.
=20 =20 =20
When the report is exported using the Renderer, Reporting Services retri= eves the data from the queries and data source locations stored in the RDL.= It passes this data along to whichever renderer was selected for exporting= the report.
The OfficeWriter Renderer loads the copy of the Excel or Word template f= ile and binds the data from Reporting Services to the template. The Rendere= r is actually using ExcelTemplate or WordTemplate to bind the dat= a to produce the output.
=20 =20 =20
The default renderering extensions for Reporting Services deliver flat, = static output. In order to render for multiple extensions such as HTML and = PDF, the basic report design cannot accomodate specific features, such as m= ultiple worksheets in Excel. This also means that certain features like cha= rts cannot be dynamic in the output because not all the rendering extension= s support Excel charts, so charts are exported as images. Also, until SSRS = 2008 R2, there wasn't a default rendering extension for Word.
Using OfficeWriter for Reporting Services allows end-users to Design rep= orts in Excel and Word and make use of many specific features in those appl= ications.
Interested? Learn more about OfficeWriter for SQL Server Reporting Services!