Message-ID: <1540795896.8945.1711668902697.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8944_215261692.1711668902697" ------=_Part_8944_215261692.1711668902697 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html OfficeWriter Designer vs OfficeWriter Designer .NET

OfficeWriter Designer vs OfficeWriter Designer .NET

= Overview

 

OfficeWriter Designer .NET was introduced in version 8.6.= 0 of OfficeWriter. It is a completely rewritten version of our Excel Design= er add-in using more modern technologies than the existing OfficeWrite= r Designer. The OfficeWriter Designer .NET is written in .NET/C# = using VSTO (Visual Studio Tools for Office). It has no dependence on COM or= VBA. The new Designer .NET has better platform support (i.e. 64-bit Office= ) and is more robust. However, it does not yet support all of the features = found in the original Designer. Additional functionality will be added to f= uture releases of the Designer .NET.

Benefits of OfficeWriter Designer .NET

Limitations of Designer .NET

Details

Platform=

Feature

OfficeWriter Designer .NET

OfficeWriter Designer

Office 2007

Excel 2007 (up through SP3)

Excel and Word 2007 SP2 or SP3

Office 2010

Excel 2010 (32-bit and 64-bit)

Excel and Word 2010 (32-bit only) SP1

Office 2013

Excel 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
Lat= est Microsoft service pack
Security Bul= letain MS-012-060

SQL Server Reporting Services Version

Feature

OfficeWriter Designer .NET

OfficeWriter Designer

SSRS 2005

Not supported

RDLs created in VS 2005 supported.

SSRS 2008 (R2)

RDLs created in Visual Studio 2008/2010, Repo= rt Builder 3.0

RDLs created in Visual Studio 2008/2010, Repo= rt Builder 3.0

SSRS 2012

RDLs  created in Visual Studio 2010/2012= , Report Builder 3.0

RDLs created in Visual Studio 2010/2012, Repo= rt Builder 3.0

Basic Designer Functionality

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 f= ormat.

Defaults to XLS for each save. Does not remem= ber 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<= /li>
  • 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<= /p>

Supports inserting data markers (Excel)

Supports inserting data markers (Excel), merg= e fields (Word) and defining repeat blocks (Word)

Native query builder

Not currently supported

Available through MS Query integration

= Report Robustness

Feature

OfficeWriter Designer .NET

OfficeWriter Designer

Modifying data sets in Visual Studio or Repor= t Builder

Safe actions: 

  • Add or remove data sets
  • Rename data sets

Safe actions: 

  • Add new data sets

Modifying fields in queries in Visual Studio = or Report Builder

Safe actions: 

  • Add or remove fields
  • Rename fields

Safe actions: 

  • Add new data sets

SQL Server Reporting Services RDL Features

Feature

OfficeWriter Designer .NET

OfficeWriter Designer

Shared data sources

  • Fully supports RDLs that store absolute paths to shared data sources (i= .e. RDLs created in Report Builder 3.0). 
  • When publishing RDLs that only contain the shared data source name (i.e= . RDLs created in Visual Studio) to a new folder on the server, it may be n= ecessary to update the reference to the shared data source through Report M= anager.
  • Unable to View reports created from shared data sources in Visual Studi= o.

Correctly handles shared data sources with ab= solute and relative paths stored in the RDL

Report Models

Not currently supported

Supported

Formulas/expressions defined in Visual Studio= or Report Builder

Not currently supported

Not currently supported. * 

OfficeWriter De= signer provides a limited set of similar formulas that are exclusively visi= ble in the Designer. 

See Backwards Compatibility for OfficeWriter Report= ing Services formulas for more information.

SHAREPOINT

 

 

Open from a report library

Not currently supported

SharePoint 2007 supported

Save to a report library

Not currently supported

SharePoint 2007 supported

Backwards Compatibility with OfficeWrite= r Designer files

OfficeWriter Designer Feature

OfficeWriter Designer .NET Support

RDLs with OfficeWriter Reporting Services for= mulas

Formulas will be preserved. Reports that have= formula data markers will still populate the formulas. Formulas are not ac= cessible for adding, removing, or modifying in Designer .NET

RDLs with Word templates from OfficeWrit= er Designer

Fully backwards compatible.

RDLs with Excel templates from OfficeWriter D= esigner

Fully backwards compatible.

RDLs created from MS Query integration in the= OfficeWriter Designer

Not currently supported.

------=_Part_8944_215261692.1711668902697--