{section}{column:width=48%}

h1. New in SSRS Integration 8.0!
{div7:style=kate-style}
SSRS Integration in OfficeWriter 8.0 does this...
Other exciting new things!!
Isn't ExcelWriter 8.0 awesome??
{div7}
{column}{column:width=52%}

{panel:title=SSRS Integration Documentation Sections|borderColor=#BBB|bgColor=white|titleBGColor=#EEE|titleColor=#444}{children:depth=2}{panel}

{column}{section}

h1. SSRS Integration 8.0 Documentation

{children:style=h4|excerpt=true}

{excerpt:hidden=true} The gist of ExcelWriter, and how to start producing reports quickly. {excerpt}
{div:class=kate-style}
{section}
{column:width=30%}
{div2:class=button-style}
[Installing OW Designer|Automatic Installation]
{div2}
{div2:class=button-style}
[Installing OfficeWriter| Docs:Installation (old)]
{div2}
{div2:class=button-style}
[Hello, World! Tutorial|Hello, World Tutorial]
{div2}
\{column}{column:width=70%}
h1. What is SSSRS Integration?
OfficeWriter Reporting Services Integration enhances [Microsoft SQL Server Reporting Services|http://www.microsoft.com/sql/reporting/] by allowing users to design and deliver their reports in native Word and Excel. The OfficeWriter Designer is a toolbar add-in for Microsoft Excel and Word. It allows the user to design a report [template|what is an officewriter excel template?] in Excel or Word instead of Visual Studio. The template is then  	integrated into the Reporting Services xml-based [Report Definition File (RDL)|Microsoft RDL files] format for publishing on the reporting server. The renderer runs on the Reporting Services server. The renderer interprets the template information that was added to the RDL file with the OfficeWriter Designer and populates the template with data supplied by Reporting Services.
{column}
{section}
h1. Standard Edition vs. Enterprise Edition

h1. Tutorials
{div}

OfficeWriter Reporting Services Integration enhances [Microsoft SQL Server Reporting Services|http://www.microsoft.com/sql/reporting/] by allowing users to design and deliver their reports in native Word and Excel.  Reporting Service Integration is a two part solution:
* *The OfficeWriter Designer*
The OfficeWriter Designer is a toolbar add-in for Microsoft Excel and Word. It allows the user to design a report [template|what is an officewriter excel template?] in Excel or Word instead of Visual Studio. The template is then  	integrated into the Reporting Services xml-based [Report Definition File (RDL)|Microsoft RDL files] format for publishing on the reporting server. \\ \* *The OfficeWriter Renderer*
The renderer runs on the Reporting Services server. The renderer interprets the template information that was added to the RDL file with the OfficeWriter Designer and populates the template with data supplied by Reporting Services.

Using Reporting Services without OfficeWriter, the report designer uses a tool such as Visual Studio to design queries, specify data sources, and generate an RDL file that will be published on the Reporting Services server. Since Visual Studio is a development tool, designing a report likely requires a developer.  Using OfficeWriter Reporting Service Integration, two workflow options exist:

h1. Option 1: Adding a Template to an Existing Report

The OfficeWriter Designer can open existing RDL files. When a user opens an RDL file in Word or Excel, only its database queries are available for use. The query fields appear in a drop-down list on the OfficeWriter toolbar.  The user can insert these fields as data placeholders in the report template and cannot create additional queries.   When the user saves the file, the OfficeWriter template information is added to the RDL file.  The advantages of adding a template to an existing RDL file are: \* *Two Display Formats*  Render the original report design or view the report as a Word or Excel file. \\ \* *Separation of Report Design Roles*  A developer may be responsible for creating shared data sources on the server and defining SQL queries in RDL files. A business user can then open an RDL, insert field placeholders from the predefined queries, and design a report.

h1. Option 2: Create a New Template Report

When you create a new template report without an existing RDL file, the OfficeWriter Designer allows you to set a data source and create database queries in Word and Excel. With this approach, the business user can be entirely responsible for both creating queries and designing the report.  This option is not enabled by default by security reasons, but can be enabled by changing a single registry key value.