...
- 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 Basic for Applications (VBA) |
...
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, Report Builder 3.0 | RDLs created in Visual Studio 2008/2010, Report Builder 3.0 |
SSRS 2012 | RDLs created in Visual Studio 2010/2012, Report Builder 3.0 | RDLs created in Visual Studio 2010/2012, Report Builder 3.0 |
SSRS 2016 | RDLS created in Visual Studio 2010+, Report Builder 3.0, or SQL Server 2016 Report Builder |
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 format. | Defaults to XLS for each save. Does not remember last-saved file format. |
View |
|
|
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 builderNot currently supported | Available through MS Query integration | Available through MS Query integration |
...
Feature | OfficeWriter Designer .NET | OfficeWriter Designer | ||
---|---|---|---|---|
Shared data sources |
| Correctly handles shared data sources with absolute 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 |
SHAREPOINT |
|
| ||
Open from a report library | Not currently supported | SharePoint 2007 supported | ||
Save to a report library | Not currently supported | SharePoint 2007 supported |
...
OfficeWriter Designer Feature | OfficeWriter Designer .NET Support |
---|---|
RDLs with OfficeWriter Reporting Services formulas | Formulas will be preserved. Reports that have formula data markers will still populate the formulas. Formulas are not accessible for adding, removing, or modifying in Designer .NETFully backwards compatible. |
RDLs with Word templates from OfficeWriter Designer | Fully backwards compatible. |
RDLs with Excel templates from OfficeWriter Designer | Fully backwards compatible. |
RDLs created from MS Query integration in the OfficeWriter Designer | Not currently supportedFully backwards compatible. |