A new template Design Studio is used to produce report templates. It is an alternative choice to the our addin in Microsoft Excel, providing all the features required to design professional
looking templates. Formatting, formulas and charts in an environment this is immediately inviting.
The new Design Studio completes our mission to design, produce and distribute workbook reports without needing to deploy Microsoft Excel.
Template Library
The template library has been re-organized for easier access to the “out-of-box” templates.
Templates are either fully functional or will provide an excellent starting point for customization.
In either case, the User needs to specify the connector and a few other parameters to produce reports in a few minutes.
Data Connections
Named Ranges
Cell references in data or Management connections can be expressed as a Named Range as well as a cell reference.
As rows and columns are added/removed from a worksheet, the Named Range name remains the same but the underlying cell reference changes,
Use Name Ranges to stack blocks of data on top of each other.
Cell Action – By Value
This management function is used to perform actions based on cell value conditions.
Cell Action – By Value In Range
This management function is used to perform actions based on range value conditions.
Cell Action – By Row Iteration
This new management function processes a range of cells and for every row in the range sets variables with the values in the cells of the row and triggers a specific action to update the report.
Presentation - 2D Transformation
The Clear Data setting now clears the entire Base range specified rather than just the Row Offset, Column Offset and Data Range ranges.
Connectors
HMS Networks Ewon Flexy
The Ewon Flexy connector makes Internet of Things (IoT) reports and dashboards in easy reach of anyone, anywhere.
The connector uses the data and alarms collected by the Ewon Flexy from remote locations anywhere in the world.
The Ewon Flexy and XLReporter use the Talk2M cloud provided by HMS Networks which is available at no cost
Siemens SIMATIC
Support for alarms in multiple languages is available which was previously restricted to English.
This change allows users across the world to now produce ISA18.2 Alarm Management reports in their native language.
ICONICS
Iconic connectors for the GENESIS64 OPC DA server and the Hyper Historian OPC HDA servers.
Database
The connectors to databases support timestamps that are either in local format or UTC format. When timestamps in a database are UTC,
the user submits their dates and time periods in local format to receive results from XLReporter in local format.
Database Manager
An option is available to run database scripts from the Database Manager. A database script is a text file that contains a list of SQL commands to run against the database specified in the selected connector.
Database script files have the file extension .dbc and must be saved in the Data folder of the project in order to be selected to run.
PostgresSQL
When configuring a connector to a database, PostgreSQL is now available as an option. This requires the PostgreSQL ODBC driver to be installed.
This can be downloaded from the PostgreSQL website (https://www.postgresql.org/ftp/odbc/versions/msi/ ). If the operating system is 64 bit, both the 32 and 64 bit drivers must be installed.
SQLLite
When configuring a connector to a database, SQLite is now available as a choice. This requires the SQLite ODBC driver to be installed. This can be downloaded from www.ch-werner.de/sqliteodbc/.
If the operating system is 64 bit, both the 32 and 64 bit drivers must be installed.
Other
OPC DA Performance
Data retrieval from OPC DA servers is now 10 times faster, 5000 values in less than 10 seconds.
Secure FTP
The FTP client application now supports transferring files to and from an SFTP server. When specifying the Server settings, set Encryption to SFTP.
Note, Login Information must be specified, SFTP does not support anonymous logon.