---

New Features

Template Design

• Support for 50 new Excel 2013 functions as well as the Excel 2010 AGGREGATE function.
• Excel 2016 compatible conditional formatting including Icon Sets, Data Bars, Color Scales, Highlight Cells, Top n / Bottom n Rules. No limit to the number of rules per cell.
• Autofilter by font color, cell color and conditional format icon.
• Support for reading, writing, modifying and rendering gradient cell backgrounds.
• Support for reading and writing encrypted workbooks with the new Agile Encryption used by Excel 2013 and later including default SHA-512 encryption for workbooks.

Data Connectors

• Tatsoft FactoryStudio
New connector for the Tatsoft FactoryStudio HMI. Support for real time, historical and alarm data.
• GE Historian
Connector update to support Boolean types and milliseconds.
• FactoryTalk View Alarm and Events
Connector update to handle the EventTimeStamp expressed as text.
• Text Historian
Connector update to support encoded text files.
• Database (time series)
Support for databases that record timestamps as UTC time or UTC ticks rather than local time. The connectors for Historical values (wide), Alarms as well as specific connectors like DeltaV Event Journal and other specific alarm connectors provide an option to specify the format of the timestamp.
• Siemens WinCC/PCS7 Alarms
Modified so that a single connector is used to retrieve data from the both the AlarmView table and the AlarmHitView table.

Data Entry Forms

Support for both 32 and 64 bit Microsoft Access.

Programming Interface

Update to the programming interface so that XLReporter actions can be performed from a 32 bit and 64 bit Visual Basic (or VBA) environments.

PDF Report Viewer

The PDF Viewer is updated to support fonts and objects used in the newer versions of Excel. The viewer does require Adobe Reader to be installed in order to function properly. XLReporter has been tested extensively with Adobe Reader XI but does work with both older and newer versions. An installation of Adobe Reader XI can be found on the XLReporter installation CD as well as at www.SyTech.com.

Data Management

• Worksheet Functions
  Hyperlink Range
  A function to expand Excel’s HYPERLINK function to provide dynamic hyperlinks in a worksheet published as a web page or PDF document.
  Text Range to Column
  The Delimiter parameter now provides some common choices including tab and space as a drop down list. Custom characters are supported.
• Data Import Functions
  From Text File
  The Delimiter parameter now provides some common choices including tab and space as a drop down list. Custom characters are supported.

Enhancements

Excel 2016 Templates

A “Corrupt Open XML Document” error may occur on workbooks saved with the latest service pack of Excel 2016. This error has been corrected.

Data Group Preview

With certain licenses, the preview of a data group would return nothing despite the correct components enabled. That is now corrected so that Preview reflects exactly what is enabled in the license.

Data Management

Data Export To Database If the export is set up to use Commands from a worksheet and the command contained data surrounded by single quotes, in some cases a second set of single quotes would be added to the command before it was sent to the database which would cause an error. This functionality has been removed, when commands are used they are used “as is” so single quotes or any other delimiters required by the specific database need to be specified.

OPC HDA Server

Tag Browser
With some OPC HDA servers, tags were not being shown when certain “branches” of the server were selected if that branch also had “branches” below it. This has been corrected so that tags are shown at any selected “branch” of the server.

Raw Data Retrieval
Previously a 100,000 row limit was applied to raw value retrieval. This has been removed to accommodate historians that have no limits.

FactoryTalk Historian SE (VantagePoint)

Corrected issue where discrete data was not being returned. Now, if discrete values are retrieved with a Raw Values data group, a 0 or 1 is returned. If discrete values are retrieved with a Raw Text data group, True or False is returned.

FactoryTalk View Data File(s)

If the tag name or value contained a “,” an error would occur. This has been corrected to handle “,” in both fields.

FactoryTalk Alarm and Events

In some versions of the database the timestamp is set as a different column type which caused no data to return. This has been corrected to handle the timestamp in any format.

FactoryTalk Historian (OLEDB/ODBC) and OSIsoft PI Historian

String data was not being returned correctly to the report. This has been corrected.

GE Historian Plus

Using a raw values data group if multiple tags were requested and each tag was logged at a different frequency, errors would occur or data would be repeated. This has been corrected to show only what is returned from the historian.

InTouch Classic History

If the date separator set in the Windows Operating System was not “/”, no data would be returned. This has been corrected so the date separator can be anything supported by the OS.

XLReporter Analytics

The last recording was not always being written to the report. This has been corrected.

Version 12.4 Summary