Page tree

Versions Compared

Key

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

...

  • Does not update references to shared data sources when publishing to a new folder on the report server. It may be necessary to update shared data source file paths through Report Manager.
  • OfficeWriter Designer .NET is only available in Excel
  • Unable to retrieve or publish directly to/from a SharePoint report library

...

Feature

OfficeWriter Designer .NET

OfficeWriter Designer

Office 2007

Excel and Word 2007 (up through SP3)

Excel and Word 2007 SP2 or SP3

Office 2010

Excel and Word 2010 (32-bit and 64-bit)

Excel and Word 2010 (32-bit only) SP1

Office 2013

Excel and Word 2013 (32-bit and 64-bit)

Excel and Word 2013 (32-bit only)

System requirements

.NET 4.0 or higher
Visual Studio 2010 Tools for Office runtime (VSTO)

Visual Basic for Applications (VBA)
MS Query
Latest Microsoft service pack
Security Bulletain MS-012-060

...

Feature

OfficeWriter Designer .NET

OfficeWriter Designer

Open a report (server/disk)

Prevents users from opening multiple reports at once

Users can open multiple reports at once which may lead to corrupted reports. 

Save a report (server/disk)

Defaults to XLSX. Remembers last-saved file format.

Defaults to XLS for each save. Does not remember last-saved file format.

View

  • Does not require an RDL to be open in the Designer .NET to view
  • Supports selecting multiple values and cascading parameters in addition to basic parameters
  • Requires an RDL to be open in the Designer to view a particular report
  • Supports basic parameters

Import a template

Supported

Supported in Excel and Word

Report properties

Available in the toolbar

Can only be edited when saving to disk

Insert data place holders based on data sets

Supports inserting data markers (Excel) and merge fields (Word)

Supports inserting data markers (Excel), merge fields (Word) and defining repeat blocks (Word)

Native query builder

Available through MS Query integration

Available through MS Query integration

...