XLReporter Version 15

Connect, Design, Report and Publish.

Table of Contents

Version 15.01
Version 15.0

Version 15.01

New Features

HMS Ewon DataMailbox

As a security measure, HMS has deprecated user/password authentication for the Data Mailbox API (DMWEB) and now only allows token-based authentication. The Ewon DataMailbox connector has been updated to support this change. Existing XLReporter applications using this connector must be updated to version 15.01, and the connector settings must be modified to use token authentication.

New Connectors

Emerson Automation Solutions

The DeltaV Continuous Historian (OPC UA HA) connector is available to retrieve both raw and summary data from the DeltaV Continuous Historian using the OPC UA HA server.


A general OPC UA HA connector is available to retrieve historical data (both raw and summary) from any OPC UA HA server.

Schneider Electric

The EcoStruxure Geo SCADA Expert Alarms and Events connector is available to retrieve alarm and event records from Geo SCADA using the Geo SCADA OLE DB provider.

Improvements and Issues Fixed


Distributed Edition


Template Library

Email and SMS

On Demand Designer

Stack Wizard

Database Data Group

Design Studio

Data Management

Version 15.0

New Features

Stacked Reports

Stacked Reports are a new dimension of reporting by “stacking” sub reports. By specifying a few basic settings, the Stack Wizard produces a multi-dimensional template ready for reporting and dashboards. Common uses of stacked reports are: The foundation of stacked reports is a database table that provides the process conditions that determine the stacking process. An example of such as database table is the XLReporter Event Frame database.

Event Library

Event Frames capture the timestamps of two events in the process (from live data) along with other process data. They are commonly used to represent the time frame of discrete processes such as batching times and machine cycles.
Event Frames can be stored to a database in which case they can be used as the time basis for discrete and stacked reports.
Support for the following functionality is provided:

Template Library

Naming Convention and Schedule
When using the template library to create a scheduled template, the naming convention and schedule settings for the template are exposed in the library so they can be edited directly before the template is created.

Event Frames
The template library has been updated with a new Reporting Method: On-Demand from Event Frames. Prior to this version, a template library configured for On-Demand would typically allow the user to select start and end times using a calendar control.

This new method presents a user with a list of Event Frames, e.g., a list of batch names, and automatically sets the start and end of the report based on the user’s selection.


New variable types provide events to trigger a report and new mechanisms for components to share information:

Action Lists

In previous versions, every Scheduler Action would need to be specified as separate lines in the scheduler. Action Lists group a set of actions and have them performed on a single Condition using the new Update Action List. An action list builder is provided to specify the list of actions. This replaces Schedule Scripts.

Scheduler Action Delay

Action Delay is added for the update Actions such as UpdateWorksheet. This delay is useful when the production of report needs to be delayed to allow the data source complete before it is read.

Data Entry Form Filter

Custom Filters have been added to data entry forms that custom what is displayed when the form is opened and what is stored to the database when the form is saved. The filter is specified in user-configurable SQL syntax.

Email and SMS

Support for blind carbon copy (BCC) is added in the recipient list.

Data Management

New functions to Data Management:

Status Logs

The Status Logs are used to hold reporting action history. More detailed information is provided in error messages.

Task Monitor

More detailed information is provided for diagnosing runtime performance issues.

Database Manager

Database Manager has been expanded to perform additional database functions such as creating, editing, and populating database tables. Indexing can also be added to improve the runtime performance of data retrieval.

New Connectors


An improved OPCUA connector for retrieving process data using a more comprehensive set of authentication and encryption techniques.


The WIN-911 data connector is used to interface with the database managed by the WIN-911 alarm notification system. Templates have been added to the template library to give WIN-911 users “out of box” feedback on the performance of the alarm notification system.

Improvements/Issues Fixed

.NET Framework Installation Prerequisite

Code Signing


Reporting Engine/Collector

Data Management

Data Connectors

Design Studio

Email and SMS

History Data Group

On-Demand Designer

On-Demand Reports

Variable Browser

Variable Editor

Web Portal

Windows Team Client