Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width48%

New in OfficeWriter 8.4!

Getting started

Column
width52%
Panel
bgColorwhite
titleBGColor#EEE
titleSSRS Integration Documentation Sections
borderColor#BBB
titleColor#444
Children Display
styleh4
depth2
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:

50%50%
Section
Column
width
35
title
Panel
bgColor
white
titleBGColor#EEE
#f6fbfc

The OfficeWriter Renderer

borderColor#AAA
titleColor#666

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
width
35
title
Panel
bgColor
white
titleBGColor#EEE
#f6fbfc

 The OfficeWriter Designer

borderColor#AAA
titleColor#666

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.

Benefits over the native SSRS Renderers

Full Excel Rendering

  • OfficeWriter allows Microsoft Excel users to maintain and create spreadsheets that contain:
    • Pivot tables
    • Interactive charts
    • VBA and macros
    • Advanced formulas
  • OfficeWriter allows you to separate roles of query developer and report designer. A developer can create shared data sources and build queries, and a business user can design the report in Word or Excel.
  • OfficeWriter delivers reports directly from Excel or Word. Use the OfficeWriter toolbar to browse the Reporting Services server and display the OfficeWriter rendered reports directly in Office.
  • The familiar Word and Excel design environments eliminate the learning time required by more complex development environments like Visual Studio .NET.
  • Avoid the cost of additional Visual Studio licenses by using the freely-distributed OfficeWriter designer in Word or Excel.
  • OfficeWriter generates real RDL files, allowing you to take full advantage of Reporting Services' report management, security, and delivery options.

Full Word Rendering

  • The Microsoft Word format has only limited support in Reporting Services 2008 and no support in Reporting Services 2005 without the use of OfficeWriter.
  • OfficeWriter delivers reports directly from Excel or Word. Use the OfficeWriter toolbar to browse the Reporting Services server and display the OfficeWriter rendered reports directly in Office.
  • The familiar Word and Excel design environments eliminate the learning time required by more complex development environments like Visual Studio .NET.
  • Avoid the cost of additional Visual Studio licenses by using the freely-distributed OfficeWriter designer in Word or Excel.
  • OfficeWriter generates real RDL files, allowing you to take full advantage of Reporting Services' report management, security, and delivery options.

 


 

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