Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel

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.

 


 

Column
width50
Panel

Getting started with SSRS Integration

 

Panel
borderStylenone

Topics


Children Display
pageTopics

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

Creating Your First Report


Children Display
pageCreating Your First Report

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

Server Side Renderer Configuration


Children Display
pageServer Side Renderer Configuration

Column
width50
Panel

SSRS Integration for Excel

Panel
borderStylenone
titleSSRS Integration for Excel

 How to Create Excel Reports

The OfficeWriter Designer .NET for Excel

The OfficeWriter Designer for Excel


SSRS Integration for Word

Panel
borderStylenone
titleSSRS Integration for Word

 How to Create Word Reports

The OfficeWriter Designer for Word

...