New features in Historian Client 2023 R2

Ad-Hoc expressions in Trend

Historian Client Desktop Trend control and its embedded ActiveX controls now support Ad-Hoc expressions. The Expression application and pane now appear in the Tag Picker with the Textbox editor.

For embedded ActiveX controls, scripting is supported for ad-hoc expressions in InTouch applications.

Ad-hoc expressions are supported with both SQL and REST connections.

Expanded ad-hoc expression functions

New functions added to ad hoc expressions make results simpler and more valuable.

Runtime language switching

Runtime language switching is supported for Trend Control, Query Control, Embedded control, and the Excel and Word ActiveX controls. It's supported for the following fields:

• Description

• Engineering Unit

• Message On/Message Off

• Alias

If there is no value for the requested language for a field, the default language is used.

Improved Trend control for InTouch

Configuration is simplified for the Trend control within InTouch. The control is available in the graphic editor and can be placed in InTouch directly.

AVEVA Identity Manager Server login

Trend and Query support single sign-on authentication with AVEVA Identity Manager. This is restricted to REST-based connections and is not available for SQL-based connections.

Additional script functions for OMI Trend App and Graphic Editor support

The event tags TagAdded and TagRemoved have been added and are available at the Graphic level and in the HistoricalTrendApp control.

General performance improvements

Performance has been improved across the Historian Client controls.

Microsoft Office Historian Client Workbook improvements

The classic Historian Client Workbook add-in has been updated. Note the following:

• Microsoft Office is optional. If you install Office after installing Historian Client, the Historian Client add-ins do not appear in the list of Office add-ins. Run the Historian Client installation program and repair the installation to load the Office add-ins.

• When you perform a custom installation of Microsoft Office (32-bit), you must install Office Shared Features and Office Tools so that the Historian add-ins for Workbook or Report can be loaded.

  Note: Make sure that you are not using the 64-bit version of Microsoft Office.

Tool for migrating from Historian Client Workbook to the newer Excel task pane add-in

The Excel Migration Tool updates Excel workbooks created in Historian Client Workbook to formulas compatible with the newer Historian Excel task pane add-in.

This tool is supported for files created in Excel 2016 or later.

For more details, see the Migrate data from Historian Client Workbook to the Excel add-in section in the AVEVA Historian Client User Guide.