Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
{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}
Panel

Image Added

What is SSRS Integration?

OfficeWriter Reporting Services Integration enhances Microsoft SQL Server Reporting Services by allowing users to design and deliver their reports in native Word and Excel. Reporting Service Integration consists of two components:

Section
Column
width35
Panel
bgColor#f6fbfc

The OfficeWriter Renderer


The OfficeWriter renderer runs on the Reporting Services server.

The renderer takes a template RDL file that was designed using the OfficeWriter Designer, and populates it with data supplied by Reporting Services.

Column
width35
Panel
bgColor#f6fbfc

 The OfficeWriter Designer


The OfficeWriter Designer is a toolbar add-in for Microsoft Excel and Word.

With the OfficeWriter Designer, you design a report in Word or Excel. Any formula, charts, or other advanced Office functionality will be present in the output file when the report is run.

 


 

Panel
borderStylenone

Getting started with SSRS Integration

Column
width33
Panel
borderStylenone

Topics


Children Display
pageTopics

Column
width33
Panel
bgColorwhite
titleBGColor#EEE
borderStylenone
borderColor#BBB
titleColor#444

Creating Your First Report


Children Display
pageCreating Your First Report

Column
width33
Panel
bgColorwhite
titleBGColor#EEE
borderStylenone
borderColor#BBB
titleColor#444

Server Side Renderer Configuration


Children Display
pageServer Side Renderer Configuration

Column
width49
Panel
borderStylenone

SSRS Integration for Excel


Column
Panel
borderStylenone

How to Create Excel Reports


Children Display
pageHow to Create Excel Reports
depth1

Column
Panel
bgColorwhite
titleBGColor#EEE
borderStylenone
borderColor#BBB
titleColor#444

The OfficeWriter Designer .NET for Excel


Children Display
pageThe OfficeWriter Designer .NET for Excel
depth1

Panel
bgColorwhite
titleBGColor#EEE
borderStylenone
borderColor#BBB
titleColor#444

The OfficeWriter Designer for Excel


Children Display
pageThe OfficeWriter Designer for Excel
depth1

 

 

Column
width50
Panel
borderStylenone

 SSRS Integration for Word


Column
Panel
borderStylenone

How to Create Word Reports


Children Display
pageHow to Create Word Reports
depth1

Column
Panel
bgColorwhite
titleBGColor#EEE
borderStylenone
borderColor#BBB
titleColor#444

The OfficeWriter Designer .NET for Word


  • Coming soon!
Panel
bgColorwhite
titleBGColor#EEE
borderStylenone
borderColor#BBB
titleColor#444

The OfficeWriter Designer for Word


Children Display
pageThe OfficeWriter Designer for Word
depth1