Release Notes

 

AVEVA Reports

for Operations

 

Version 2023

 

User Friendly Programming-Free™ Reporting for Automation

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Contents

 

Release Notes. 1

Summary of New Functionality and Enhancements for AVEVA Reports Release 2023 (compared to the original version 2020 R2 SP1) 3

Corrected Issues/SCRs (AVEVA Reports 2023) 5

Corrected Issues/SCRs (AVEVA Reports 2020 R2 SP1) 7

Summary of New Functionality and Enhancements for AVEVA Reports Release 2020 R2 (compared to the original version 5.0 R20-3) 9

Corrected Issues/SCRs (AVEVA Reports Release 2020 R2) 10

Summary of the New Functionality and Enhancements for Dream Report Release 5.0 R20-3 (compared to the original version 5.0 R20-2) 11

Corrected Issues/SCRs (Dream Report 5.0 R20-3) 12

Summary of the New Functionality and Enhancements for Dream Report Release 5.0 R20-2 (compared to the original version 5.0 R20-1) 13

Corrected Issues/SCRs (Dream Report 5.0 R20-2) 15

Summary of the New Functionality and Enhancements for Dream Report Release 5.0 R20-1 (compared to the original version 5.0 R19-3) 16

Corrected Issues/SCRs (Dream Report 5.0 R20-1) 18

Summary of the New Functionality and Enhancements for Dream Report Release 5.0 R19-3 (compared to the original version 5.0 R2) 19

Corrected Issues/SCRs (Dream Report 5.0 R19-3) 21

Summary of the New Functionality and Enhancements for Dream Report Release 5.0 R2 (compared to the original version 4.83) 22

Corrected Issues/SCRs (compared to the previous version 4.83) 26

System Requirements. 29

To buy AVEVA Reports for Operations. 30

Contact Technical Support 30

 

Summary of New Functionality and Enhancements for AVEVA Reports Release 2023
(compared to the original version 2020 R2 SP1)

 

Module

Description

New Features

 

 

 

[Web Clusters]

Web Cluster feature allows users to specify a report area (report cluster) with one or multiple objects, and provide a URL to that specific cluster, so that it can be published in any external web content container.

 

[Report Levels]

User Authorization for report levels – in Studio configuration

User Authorization for report levels - Runtime support

User Authorization for report levels - Web portal support

 

[Security]

New e-Signature functionality to enhance user experience for electronically signing reports:
new “signed” states; location of unsigned reports; notification for reports pending for signature, changes in use of PINs

 

[Security]

URL White List URL – option to specify which embedded URLs in reports are approved/acceptable

 

[Web]

Named Web Clients – option to reserve web client licenses for specific named users.

 

[Web]

Web reports display options: for PC or Mobile. Introducing a new option to set report type.

Other Enhancements

 

 

[Designer Studio]

Object Tree moved from the left side to the right side of Designer Studio – improved UI for larger projects.

 

[Web]

Web Portal customization - added ability to configure both custom Project Name, and custom Welcome Message, in the web portal

 

[Web]

Reloading project shouldn't reset web display to a Welcome page, if report was opened through WebAPI

 

[Remote Development]

Add timestamp information for revision history in concurrent development mode.

 

[Security]

Following External Cyber Security Audit, security enhancements were implemented in the Web Portal.

 

Comm. Drivers updates

 

 

[AVEVA Alarms ODBC]

New AVEVA Historian historical alarms ODBC driver

 

[AVEVA Insight OEE]

New AVEVA Insight Performance (OEE) historical data driver

 

[Eurotherm Reviewer Driver]

Support of SQC (SQL-based filtering) in new Reviewer driver

 

[OSIPI Web API]

New OSI PI web-based API historical data access driver

 

[BACnet Driver]

BACnet driver recompilation with new SDK v75, and removing license limitation for BACnet drivers

 

[Siemens Desigo CC Driver]

New Siemens Desigo CC system historical values driver, based on web REST API

 

Rockwell Automation PLC Real-time driver

General stability improvements and corrections in UI

 

Units Support

Added Units support for the following drivers:

AVEVA Historian, GE Proficy Historian, Advanced ODBC driver, and in Data Models

 


Corrected Issues/SCRs (AVEVA Reports 2023)

#SCRs

Module

Description

SD-2664

[Web]

Timepicker does not support font modified settings in web portal

SD-3350

[Web]

If the "Filter edit box in Web" parameter is On in SQL table, the last row of the table does not show up.

SD-3483

[Web]

Some of the web themes result in no color indication on the e-Sig “Pencil” icon tell if signed or unsigned.

SD-3542

[SPC Module]

Memory leak and exception while report generation with SPC histogram object when histogram is based on array of the same values.

SD-3543

[e-Signature]

Report opened in PDF can`t be e-signed, but it is marked as signed in the Web portal

SD-3545

[Web Chart]

Web Chart display incorrect values (rounded to integer) on tooltips and on grid on Y axis for negative values.

SD-3550

[General]

CSV and XML targets are not supported for report generation from command line

SD-3551

[Web]

Disabling Report History in Project Settings - Web portal, does not work properly

SD-3554

[Batch]

Dynamic generation on Absolute Batch ID fails from web portal

SD-3555

[AST object]

AST with vertical orientation populates value inside the Excel template in a wrong way

SD-3561

[UM]

A user who is a part of a Windows user group with admin rights, doesn’t get admin privilege

SD-3562

[Web]

Reloading reports resets Web Portal to a Welcome Page

SD-3564

[General]

Improved stability in the report generations. Unexpected behavior of Generator process.

SD-3572

[Web]

Folder management (Report Levels) in Web is not working properly, while report's generation it jumps to parent folder from selected subfolder

SD-3586

[RA FT DRV]

Browse of tags failed using FTSQL driver when type of the column TagName is varchar(255) in the DB.

SD-3588

[Web]

Error message - Missing JWT Token in Authentication HTTP Header pops up after login in Web E-signature page.

SD-3589

[Web]

Draw tables loose alignment in Web Report

SD-3592

[Adv. ODBC Alarms DRV]

Advanced ODBC Alarms driver with Custom Property with Reserved Name in SQL (User)

SD-3594

[Rem. Dev.]

User Locked status is not available in Remote Dev Mode

SD-3595

[Step Table]

Column type Row Index can`t be changed in a Step Table

SD-3597

[AVEVA\Wonderware Hist. DRV]

SQC in Batch Definitions does not work if batches are defined by data item selected from AVEVA\Wonderware Historian driver.

SD-3598

[Studio]

Dream Report crashes when right click on report free area of designer

SD-3600

[Alarm Table]

Alarm Display Filters are not applied in some Alarm Tables

SD-3601

[DBatch]

DBatch stops to write process values when batch id exceeds 32767 and SQL server or MySQL is used as project database

SD-3602

[RA FT View SE Hist. Values DB DRV]

Driver FactoryTalk View SE Historical Values DB returns wrong result for statistical function Running Time when no advanced SQL condition is used

SD-3603

[RA FT View SE Hist. Values DB DRV]

Driver "FactoryTalk View SE Historical Values DB" incorrectly handles requests with advanced SQL condition when condition tag contains "/" character, for example: //::[PLC1]Train_41_Actual_Step

SD-3604

[Web]

Web portal is not working properly when using chromium with too much reports in the project

SD-3605

[Studio]

DR Studio crashes upon adding alarms filter from FTView SE Historical Alarms, when there`s no connection to FTView

SD-3606

[Web]

Web objects are not working properly when the SQL Table has no headers

SD-3608

[OPC UA RT DRV]

OPC UA RT values driver: Test connection fails because certificate file cannot be copied

SD-3609

[SPC Module]

Incorrect configuration of SPC can lead to abnormal memory usage and generation exception.

SD-3611

[OSI PI AF DRV]

No tags browse in OSI PI Asset Framework driver

SD-3614

[AVEVA Hist. SDK (AE) DRV]

AVEVA Historian SDK (alarms/events) driver requires more waiting time to establish connection to the server.

SD-3615, SD-3418

[E-Signature]

In E-Signature configuration, text font option is not working properly

SD-3616

[General]

When SQL table receives data of type DATETIME with TIME part filled only it can lead to exception during report generation

SD-3618

[E-Signature]

E-signature page displays incorrectly (overlapped rows)

SD-3619

[Alarm Table]

Custom Alarm filter based on Custom Property with Reserved Name in SQL (User) doesn't work. Alarm table brings N/A.

SD-3620

[RCS]

Generation on event from Remote driver fails

SD-3624

[OPC UA RT DRV]

Data aren't logged in DR DB from ADISRA OPC UA real time Server.

SD-3625

[OPC UA RT DRV]

SDO brings "err" using current value from ADISRA OPC UA real time Server for some tags.

SD-3628

[RA PLC DRV}

Generator crashes in the project with multiple write-backs to Rockwell PLC`s

SD-3631

[General]

Arabic font is garbled in PDF

SD-3632

[SPC Module]

SPC Nelson Rules Calculation fails if use dynamic TagName for SPC Configuration

SD-3634

[Web]

It appears that the "Default" report instance is generated when generating a report from the Portal home page, regardless of which instance is being generated (generated by clicking the new report generation icon).

SD-3635

[Web]

Drawn objects are shifted in Web Report

SD-3636

[Adv. ODBC HDA DRV]

Wrong query for getting previous value in the Advanced ODBC Historical Values driver

SD-3637

[Web]

Option "Dynamic row height" doesn`t work in web report

SD-3638

[SQL Table]

"Open Sans" font is garbled in SQL Table in PDF.

SD-3639

[Eurotherm Reviewer DRV]

Generator crashes upon generation of the alarms report from Eurotherm Reviewer when specific set of uhh files used

SD-3640

[OPC UA RT DRV]

Write-back doesn`t work with Kepware OPC-UA

SD-3641

[Logger]

Trigger tag is recorded with another timestamp, comparing to the other tags of the group


Corrected Issues/SCRs (AVEVA Reports 2020 R2 SP1)

#SCRs

Module

Description

 

[Eurotherm DRV]

Eurotherm Review driver is using an old mdb ODBC driver. Some SQL expressions are not supported in the old ODBC driver. New ODBC driver for *.mdb, *.accdb databases to be used.

 

[FT HDA VALUES AND ALARMS DRV]

Timestamp format in SQL queries was changed due to customer request.

 

[SECURITY]

AVEVA Security Audit

 

[SECURITY]

RTM Service is installed with Local System account but has to be installed with Virtual Service Account

 

[SECURITY]

Digital signature is added to exe and dlls

 

[SECURITY]

Files in System folder can be changed by non admins

 

[SECURITY]

Syncfusion Dashboard service is installed with Local System account

 

[AVEVA DRV]

AVEVA Historian Historical Values Driver: Ability to select a column to be used for Quality value, ability to specify which values to be considered as good and ability to include NULL values into result set

 

[LICENSE]

AVEVA license check can fail after some undefined time interval

 

[GENERAL]

Tuning parameter "UsePrevPointForFirstStep" has to be disabled by default

SD-3203

[SPC]

Out of memory crash fixed.

SD-3408

[Modbus]

Dream Report log wrong values in internal DB using Modbus driver.

SD-3425

[BAR GRAPH]

In the Bar Graph, data displays are being overlapped by the adjacent bar in a group

SD-3485

[CIAT]

DR_CAIT process is not restarted with reload of DR project.

SD-3486

[BATCH]

Batch definition based on Custom View doesn't work.

SD-3490

[Rockwell PLC]

Adding tags to the logger studio from Micro Logix PLC causes to the DR studio hang.

SD-3491

[Modbus]

Issues with report generation on event from Modbus PLC

SD-3495

[InduSoft DRV]

Generation on event based on tags from InduSoft real time driver doesn't work if DR project was started before Indusoft project

SD-3500

[Driver Manager UI]

Japanese and Chinese symbols are garbled in the Driver Manager dialog

SD-3503

[GENERAL]

Spelling mistake in the "Value Range Indicator" Object Configuration.

SD-3512

[Eurotherm DRV]

Support of operator NOT LIKE in the definition the alarm filter of the Eurotherm Data Reviewer historical alarms/events driver

SD-3515

[STAT. FUNC]

Counter calculation in ADF should include the end of the period.

SD-3517

[Analytics DRV]

DR Logger does not log values on Absolute Time if data source is Data Model

SD-3519

[WEB]

In DRWeb portal, Step table and Item tables will plot in different sizes even if they have exactly the same formatting in every aspect

SD-3520

[INTOUCH ALG DRV]

AVEVA InTouch (historical alarms / events in ALG files) driver, Custom filters do not work

SD-3521

[CSV DRV]

Number of tags that can be imported from a single file is limited

SD-3522

[INTOUCH LGH DRV]

End time of the step is included in the calculation based on LGH driver data

SD-3523

[INTOUCH ALG DRV]

No data from ALG Alarms driver on particular OS.

SD-3524

[MX DRV]

ArchestrA embedded objects are not supported in hierarchical mode of MX Driver for more than 2 levels

SD-3526

[ALARMS]

Wrong calculation of the alarms duration when every alarm is counted once


Summary of New Functionality and Enhancements for AVEVA Reports Release 2020 R2
(compared to the original version 5.0 R20-3)

 

Module

Description

New Features

 

 

 

Notifier

New notification module. This module allows message exchange between users accessing the project at runtime. User can send messages with link to problematic reports directly from the Web portal.

 

Values Quality Management

Support of Value Quality when representing the data in objects like Chart, Item Table and Step Table. List of drivers that support Values quality can be found in the Help.

 

Statistical Functions

New Alarm related stat functions for ISA 18.2 compliance. Refer to the Help documentation.

 

New Eurotherm Reviewer Comm. Drivers

Added new Reviewer Eurotherm drivers HDA Item, HDA Alarms, Batch Monitor

 

 

 

 

 

 

Other Enhancements

 

 

 

 

 

 

Web

Combo box to filter report list by user rights

 

AST

Added support of Nelson Rules statistical functions to Automatic Statistical Table object

 

Web

Added support of X-Y mode in Web interactive Line Chart

 

SQL Table

Advanced data representation in SQL table as with Item Table and Alarm Table using Lua HDA driver

 

Project Audit Trail

Audit Trail – logs for communications errors from drivers AVEVA drivers, GE drivers, Rockwell Automation drivers, OSI PI drivers and OPC drivers

 

 

 

 

 

 

 

 

 

 

 

 

Comm. Drivers updates

 

 

 

OPC UA Real-time

General stability improvements

 

Rockwell Automation PLC Real-time driver

General stability improvements and corrections in UI

 

Units Support

Added Units support for the following drivers:

AVEVA Historian, GE Proficy Historian, Advanced ODBC driver, and in Data Models


Corrected Issues/SCRs (AVEVA Reports Release 2020 R2)

#SCRs

Module

Description

SD-3409

Web User Management

When report is generated using an action button from a different web report, the User Management settings are ignored.

SD-3419

Comm. Drivers

WW Alarm DB Logger (historical alarms/events database) driver. Alarm records are not combined correctly.

SD-3423

General

Improved memory management when retrieving data from DR internal history

SD-3426

Comm. Drivers

Added new filtering option “QualityDetail” in AVEVA Historian Driver

SD-3429

Comm. Drivers

AVEVA InSight driver: Test connection returns "Basic authorization failed" error if password includes "\" symbol.

SD-3431

Comm. Drivers

WW Historian Driver: Duplicate tag names in Combo Box

SD-3432

Runtime

Generator crashes on start of the project, if tag for event-based generation comes from PLC that is disconnected

SD-3433

Web Interactive Chart

Option to set the precision on tooltips in Chart.

SD-3435

SPC Module

Dynamic objects from report aren’t considered in calculation of correction factor in SPC configuration.

SD-3436

Web Portal

URL for report generation opens up a Welcome Page of DR Web

SD-3438

AVEVA Alarms Historian

In AVEVA Historian (alarms / events) driver, filters using the “Alarm_DurationMs” field does not work.

SD-3441

Comm. Driver

Fails to connect to a PLC through OPC-UA

SD-2824

Comm. Driver – OPC UA

Unable to connect to OPC UA Kepware server in encryption mode.

DEV-360

Web Portal

Web action button login and logout are not working

DEV-362

Web Portal

Support of placeholder %hostname% in text hyperlink object


Summary of the New Functionality and Enhancements for Dream Report Release 5.0 R20-3
(compared to the original version 5.0 R20-2)

 

Module

Description

Other Enhancements

 

 

 

Communication Drivers

Added new communication driver for Rockwell Automation PLC’s

 

Dashboards

Special report for Dashboard calculations to be created without scheduler settings

 

Remote Connector

Added support for writeback to the real time tags

 

Licensing

Removed limitations for Eurotherm drivers from the license provided in archestra.lic, (not in Dream_Report_WW)!

 

Licensing

Added Dashboards Option in DR for AVEVA License

 

Communication Drivers

OPC DA - Added possibility to change Update Rate parameter from configuration dialog in OPC DA driver.

 

 

 


Corrected Issues/SCRs (Dream Report 5.0 R20-3)

#SCRs

Module

Description

SD-3212

Communication Driver

CSV Driver - Add ability to select tags and force them to be string tags

SD-3369

SQL Table

 Link in SQL Table does not work if the text of hyperlink contains more than 16 characters

SD-3381

Communication Driver

Memory leaks issue in Wonderware Historian Alarm driver

SD-3382

Communication Driver

Wonderware Historian Alarm driver fix for alarm filters reset issue

SD-3396

Remote Connector

Added support for writeback to the real time tags

SD-3407

Communication Driver

FactoryTalk View SE Historical Values DB driver does not return result when it is used in a Step Table and there is no data in FT DB for the period of a table

DEV-360

WEB

"Time in UTC format" option is ignored in Batch Definition, defined in External DB

 

 

 

 

Designer Studio

Bar Graph Undo/Redo issue

 

Dynamic Token

Improved behavior of d# token

 

 

 


Summary of the New Functionality and Enhancements for Dream Report Release 5.0 R20-2
(compared to the original version 5.0 R20-1)

 

Module

Description

New Features

 

 

 

Preconfigured Object’s Panel – Designer Studio

New Panel with preconfigured object settings will allow user to select object with preconfigured settings.

 

User Management

Added new options to manage enhanced access rights for the users in the Dream Report Dev. and in the Web

 

Web Portal

New option that will allow operator to email generated report from the Web portal

 

Statistical Functions

SPC Nelson rules violation statistical function

 

 

 

Other Enhancements

 

 

 

Advanced Visualization

AVC in Step and Free SQL tables supports values taken from other columns

 

Advanced Visualization

Support of AVC in the Dynamic Web Chart set to interactive mode (create AVC info for DML)

 

Report Settings

Added number of copies that will be sent to printer once report is generated

 

Communication Drivers

Export/Import of driver definition instances to/from XML. This will allow user to transfer driver definition from one project to another.

 

Expression Object

Use 0 as result in Item Field, Expression, Compound if the calculated result returned as NA

 

Chart Object

Improved formatting of numbers on Y axis in chart without trailing zeros

 

Report Settings

Added option for emailing of CSV and XML reports in email body

 

Web Elements

“DateTime” pickers now uses project settings to show configured date time format and week start

 

Custom Script Objects

Added two new Custom Script Objects:
"SectorPie" and "SectorDoughnut"

 

Step Table

Added option to configure step correction to manage step start and end times

 

Item Table

Added decimal precision support to the Item Table object

 

Web Elements

Added new “Reset Manual Input” option into configuration of Submit Action Button.

 

Designer Studio

Implemented save/load custom units to/from INI file

 

Excel

Improved stability of Export to Excel option

 

License Information

Enhanced license information in Designer Studio to show license details even in case of an invalid license

 

 

 

Comm. Drivers updates

 

 

 

PcVue Web Services

Redundancy support in PcVue driver

 

OPC UA HDA

Improved OPC UA HDA driver, support of certificates and user authentication

 

OPC UA DA

Improved OPC UA DA (real-time) driver, support of certificates and user authentication

 


Corrected Issues/SCRs (Dream Report 5.0 R20-2)

 

#SCRs

Module

Description

SD-3338

DR Studio

DR Studio crashes upon creating Pivot Group based on Free Table

SD-3347

Communication Driver

SQC stopped working in Review HDA driver

SD-3348

Communication Driver

Locale is changed in DR project, when iFix driver is in use

SD-3332

Communication Driver

In Wonderware Historian driver, the "Filter out Quality 133" parameter does not work for statistical functions

SD-3366

Draw Table

Objects lose size when copying content of the Draw Table from empty cells into report working Area

SD-3363

Communication Driver

Test Connection to OSI Asset Framework fails when user name contains domain part domain\user

SD-3362

Batch Definition

"Time in UTC format" option is ignored in Batch Definition, defined in External DB

SD-3364

Communication Driver

A possibility to disable msec in IWS/InTouch Edge HMI External History Driver

SD-3352

Communication Driver

Rockwell RSView 32 driver (DBF). Error message when closing Communication Configuration Wizard, even if the test is OK

SD-3373

Licensing

Extra tags are added to the license count when retrieving BatchID defined in external DB

 

Dynamic Report Generator

DRG does not bring the list of batch ids for batches that are based on “Batch time” definition when batch is defined on the item from a data model

 

Communication Driver

Geo SCADA Expert historical events and alarms: timestamp of events and alarms does not correspond to local time (but corresponds to UTC)

 

e-Signature

If user has no e-signature definition, he is still allowed to sign report. This has been restricted.

 

 


Summary of the New Functionality and Enhancements for Dream Report Release 5.0 R20-1
(compared to the original version 5.0 R19-3)

 

Module

Description

New Features

 

 

 

Communication Driver

OPC UA HDA Driver has been added. It supports encryption and security certificates.

 

Chart

Implemented support of Logarithmic Scale for Chart based on LOG on base 10

 

Report Data Server

Redesign of RDS engine in term of report generations

 

Report Data Server

Added new HDA part for System Driver. This driver provides access to historical values of tags defined in data models.

 

 

 

Minor Improvements

 

 

 

Dynamic Tokens

Added possibility to use [f#] dynamic tokens in table headers for alarm, item, step vertical, step horizontal, SQL non-grouped, SQL-grouped tables.

Note: It will work on Force Object Update action from the web for the following tables: Alarm, Item, Step vertical, SQL non-grouped.

 

 

Audit Trail

Added remote development operations tracking into Audit Trail

 

Table objects

Added ability to vertically align text inside Simple Draw Table and SQL Table

 

Remote Development

New parameter for remote project session reconnects timeout:

 

<Module Name="ConcurrentDev">

    <Section Name = "Timeout">

       <Param Name = "OperationTimeout" Value = "60"/>

    </Section>

</Module>

 

Custom Objects

Add a button to open dynamic token selection dialog to select a token that can be used in Custom Content configuration

 

Chart Object

Chart reference lines enhancements

 

Web Tree Object

Context search filter implemented

 

Web Combo Box Object

Add Web Content objects to the list of "Select Objects for the Update" in Combo Box definition.

 

License

Change subscription license upgrade to use specific subscription end time

Comm. Drivers updates

 

 

 

Communication Driver

Implemented possibility to select tables in FTView SQL HDA ITEM driver

 

Communication Driver

Added Time zone parameter into configuration of GE Historian driver

 

 

 

 


Corrected Issues/SCRs (Dream Report 5.0 R20-1)

 

#SCRs

Module

Description

SD-3269

Batch Definition

Batch list is not updated properly when batch def list received as list of report instances from another combo. See attached project

SD-3271

Communication Driver

Modbus driver items defined in block are not updated correct in unsolicited mode.

SD-3275

Excel Module

A possibility to import data from Excel file with the separate columns for date and time

SD-3276

Communication Driver

StoppedBy field can`t be retrieved from BatchDetails table of Review

SD-3272

Communication Driver

Not possible to use a Group column as a filtering condition in Yokogawa Alarms driver

SD-3280

Communication Driver

TView driver: file explorer doesn’t display files.

SD-3279

Communication Driver

Logger crashes upon reload of the project, where MX driver is used

SD-3281

Communication Driver

Increase the number of characters allowed to be presented as a result of SQL Query

SD-3283

Communication Driver

Wrong timestamps retrieved from FT Historian using InfoPlatform drivers

SD-3288

Logger

Data logging stops shortly, when 2 log groups from Siemens S7 are recording frequently

SD-3284

Communication Driver

Report Generation fails to be triggered from ITME

SD-3295

Communication Driver

Generator crashes with WW Historian Alarms driver

SD-3297

Communication Driver

Slow shutdown when using WW Historian driver

SD-3298

WEB

Web Report shows Generation Error as soon as custom object SQL based Bar contains a query that brings empty result set

SD-3308

Chart

Chart shows incorrect timestamps for data when data is requested from Review during DST time change to Winter Time

SD-3306

Communication Driver

PcVue HDS Items Driver doesn't support string values.

 

 


Summary of the New Functionality and Enhancements for Dream Report Release 5.0 R19-3
(compared to the original version 5.0 R2)

 

 

Module

Description

New Features

 

 

 

External web content

External web content object enables to insert and use a web page or external documents in reports. Such external content may be a web page or a document (PDF or plain text).

 

Communication Driver

Rockwell Automation FactoryTalk real-time values driver

 

Communication Driver

Rockwell Automation FTAE database new driver for historical alarms and events

 

Communication Driver

Rockwell Automation FactoryTalk historical alarms and events via Rockwell Automation Info Platform

 

Communication Driver

Siemens S7 driver has been completely redesigned and support for 1200 and 1500 series has been added.

Minor Improvements

 

 

 

SPC

SPC configuration export/import xml file will allow user create SPC definition our of Dream Report project and apply it to the project or transfer the definition between projects.

 

GENERAL

Starting from version 5.0 R19-3 Dream Report will have new versioning approach:

Where 5.0 – is major DR version, R19-3 correspond to 3rd release in 2019. Added new string into Help About dialog that will show this information.

 

Advance Visualization

Added support of dynamic tokens in the item field widget color ranges

 

Scrip Object

Added new property type for script object to hold multiline strings

 

Multi Tag Aggregation

Currently, when editing an MTE, if you click <Enter> to go to a new line, it closes the MTE tool.  If trying to create a multi-line expression, this is a problem.

 

Report Data Server

New System Tags: Number of Reports in the project, Number of Reports in the generation queue

Important Notes

 

 

 

 

Starting from product version 5.0 R19-3 the Database Archiving feature had been removed from the product

 

 

Dynamic Dashboards version upgrade

Driver security updates

 

 

 

Communication Driver

In case of connection failure, the message will contain user and password information in ODBC Historical Alarms/Values driver

 

Communication Driver

Driver connecting string contain user and password information in "FactoryTalk View SE Historical Alarms and Events DB"

NOTE: (For more details, please, refer to the Dream Report® Help documentation)

 


Corrected Issues/SCRs (Dream Report 5.0 R19-3)

 

#SCRs

Module

Description

SD-3240

Communication Driver

Communication Configuration Wizard display in the description field for OSI Soft PI Asset Framework historical values driver that it is real-time values driver

SD-3242

Web Elements

Replacement of time period is not working from Action button when start and end of period taken from expression objects.

SD-3245

DBatch

If at least one process value is missing in one of the batches recorded by DBatch all step table will show NA's

SD-3246

Report Generator

Generator crashes when ADF is applied, based on 1 last value per day, sample-based

SD-3247

Batch Definition

When "Custom View" is used for the batch definition, every time Batch definition dialog is opened all columns for that batch will be reset.

SD-3248

Web Elements

Time Picker is not available with web interactive Pie Graph

SD-3249

Batch Management

Batch end time is not calculated correctly when external database source and SQC in Batch definition are used

SD-3257

Web Manual driver

Web Manual input with the option "Current Time" must take the time of submit action

SD-3258

Communication Driver

Browse issue with OPC-UA server (the list is not complete)

SD-3260

WEB

Update object request does not pass User name into Generator. It's not possible to retrieve User name in the expression object with help of LUA function in this case

DEV-225

Advance Visualization

Wrong AVC results in chart when digital data is used (0|1)

Wrong AVC results in Value Range Indicator script object when digital data is used (0|1)

DEV-231

Designer Studio

Report Settings Dialog - Changes made through the panel are not saved

DEV-237

RMC

RMC does not refresh list of reports when report is renamed in Studio and Refresh Reports is pressed

DEV-238

CHART

Chart doesn't display vertical lines when chart based on SQL query. Simulation project attached.

DEV-244

GENERAL

Display the total number of available web clients in Help About (Studio/RMC)

DEV-247

Communication Driver

Added check for data model name, so it cannot be the same as data source name and an opposite!

 

 


Summary of the New Functionality and Enhancements for Dream Report Release 5.0 R2
(compared to the original version 4.83)

 

Authorized users now can electronically sign reports from the DRWeb portal. This feature was developed in addition to the standalone e-Signature Console.

A new user-configurable XML output format allows users to build reports to comply with XML submission requirements of water quality reports.

Using LUA scripting, users can build their own graphical objects for reports – e.g., a circular chart object, status displays, etc.

Gantt chart, new gauges, and other graphical objects and shapes.

Create, share, and manage dashboards through user-friendly interfaces, and connect your dashboards to all your Industrial and Business data sources.

Note: This feature has limited availability for certain OEM’s

Faster updates of web reports, with uninterrupted web page refreshes.

Option to add Vertical and Horizontal reference lines based on preset or dynamic criteria/limits.

For the Web Interactive Chart, the new interactive cursors will allow highlighting of a selected area of data points on line charts.

Ability to use advanced SQL conditions, use DSN-less database connections, and improved user interface.

Dream Report becomes an “information platform” for external systems.  Expose Dream Report’s powerful data aggregation and calculation engine to other HMI’s, web portals, custom applications, etc. 

A new Dream Report OPC Server exposes the Analytic Data Server.  The OPC Server exposes the project’s data to external third-party tools as a real-time OPC data source.

The Cost module allows users to define rates and tariffs (i.e., methods and definitions calculation of Cost), and use the results of those calculations in the reports. It has support for Energy Tariffs & Billing rates/schedules for utilities billing reports.

The “Counter” statistical function has been enhanced to allow the user to specify the “totalizer” direction (increasing/decreasing counter), as well as new options for counter calculations, including simple difference (last value minus first value), up-counter, down-counter or automatic mode.  Additionally, if Cost calculations have been defined, a Cost definition can be associated with the Counter calculation.

The “Difference” statistical function is now available in the Bar Graph object.  This is useful for production counters and utility meter displays over various time intervals.

 

New option in the Web Combo box – “List of Alarm Filters”.  This enables users to select predefined alarm filters in ad hoc reports on alarms and events.

New statistical functions for alarms statistics calculations in several data objects - Maximum duration, minimum duration, maximum response time, minimum response time.

The Step Table object can enable “in-memory calculation” option in, which provides significant improvement in generation performance of the Step Table where this option is selected.  Please note that this option will impact available memory, so should be used with a reasonable amount of data.

Free for distributors, 10-tag Dream Report permanent license available.

Dream Report version 5 supports both permanent and annual subscription licensing.  For more details please contact your sales representative.

The Advanced Visualization Condition manager is a tool for creating and storing advanced visualization condition definitions, that can be later used in single data item, Automatic statistical table, Step table and SQL table.

The Time Definition manager is a tool for creating and storing time definitions for quicker use in creating reports.

New search options added to the reports tree and to the “add dynamic token” screen. Write text in the search box and the list will be highlighted.

1. UI enhancement: In data definition tab, move the line up or down in the hierarchy.

2. In the Appearance tab, two new options added:

a. Format – Real or Scientific

b. Precision.

A new button is added to the Report Settings – Email Configuration: “Send Test Mail”. This button will help user to ensure that the email settings correctly entered.

The Dream Report studio has a new panel – “Quick Info Panel”. In this panel user can find the reports list and get quick access to the report settings - time definition, scheduling and format settings.

In “Report settings” in “General” tab, when the “copy report files to folder” option is checked, uncheck the “apply to all” option to pick the report instances and copy them to a different folder.

If the FTP upload is selected, user can check the “active mode” option if the FTP server requires “Active Mode” for the connection.

Two new properties are added for the data model definition – Description of the Virtual Tag and Units

 

In the Widget configuration by double click on the Minimum or Maximum limits. User will be able to add Dynamic Token as the limits from the list of objects available in the report.

The custom object library has new set of objects in the list.

Note: It is known that if user is planning to use custom object as part of Pivot group its wont work as any other standard Dream Report object. This limitation is planned to be resolved in the next version release.

 

 

NOTE: (For more details, please, refer to the Dream Report® Help documentation)

 

 

Driver Enhancements

 

Extracting alarms from 3rd party databases using simple mapping with dynamic parameters list and alarm filters.

Exposes “system health” parameters for reporting.

The Rockwell “FactoryTalk View InfoPlatform Historical Values” connects to the FactoryTalk View product of Rockwell.

Improved driver for GE Historian historical alarms extraction.

Exposes data collected from nested/conditional rounds in IntelaTrac.

Ability to configure extraction of alarms and/or events separately, resulting in faster query times.

The descriptive names of several communication drivers have been updated to better reflect the current product names/functionality with which they work

New button added to the configuration – “Item name rules”: User will be able to remove or replace certain characters in the tag name.

New option added – Ability to communicate through encrypted port and possibility to retrieve the historical date with UTC based timestamps.

 

 

NOTE: (For more details, please, refer to the Dream Report® Help documentation)

 


 

Corrected Issues/SCRs (compared to the previous version 4.83)

 

SCR#

Module

Description

SD-3233

[GENERATOR]

A value of the report object cannot be used in the report file name.

It displays 0 instead of the object value

SD-3232

[Web Portal]

When pressing on "Refresh" Button in the "Web Trend" Report error occurs.

SD-3231

[GENERATOR]

Generator exits immediately after project start with error message in

RTM log "exit on crash" on windows 7

SD-3230

[Cost Module]

Wrong calculation result using Cost module

SD-3227

[InduSoft]

Advanced SQL Condition doesn`t work with Indusoft Historical Values driver,

using mapped item names.

SD-3226

[InduSoft]

Indusoft wizard add Indusoft legacy drivers to the project. See description.

SD-3224

[GENERATOR]

Tuning parameter from ODS.System.config TimePeriodIncludeEnd is not

considered in calculations using Advanced ODBC driver with option

timestamps in SEC FROM 01.01.1970

SD-3222

[Adv. ODBC Driver]

Hierarchy tag browse doesn`t work in the Advanced ODBC driver

SD-3221

[Citect Historian DRV]

A possibility to configure the number of days back, to search for the previous

point for Citect Historian driver

SD-3219

[SQL Table]

SQL Tables Footer are not available in Analytical Driver

SD-3217

[Web Portal]

Time picker displays selected date in a default format, ignoring Localization settings of the project

SD-3209

[Web Portal]

Generate PDF" button doesn`t work with HTTPS protocol

SD-3207

[OPC HDA DRV]

Some stat. functions don`t work with OPC HDA Boolean values

SD-3203

[SPC Module]

Exception while generation of SPC object when data source return only one value in time period.

SD-3202

[Web Report]

Zoom issue for Web reports if in the project iFix drivers was used.

SD-3200

[GENERATOR]

CSV reports are not copied upon report generation

SD-3199

[GENERATOR]

Report is generated on event from iFix upon project reload

SD-3197

[Citect Historian DRV]

No items browse in the multi-cluster Citect project

SD-3194

[InTouch ALG DRV]

Some events are missed in the Alarms Table from the InTouch ALG files

SD-3193

[Yokogawa Hist. DRV]

Some "*.gse" Yokogawa files cause crash of DR modules (Studio, Logger, Generator)

SD-3192

[Excel Driver]

DR fails to export all data from xlsx file

SD-3191

[GENERATOR]

MX Event-based report is generated upon reload of the project

SD-3190

[GENERATOR]

Boolean values False and True displayed as 0 in SQL table using query to GE iHistorian.

SD-3189

[IntelaTrack DRV]

Query text to IntelaTrack should be changed

SD-3188

[Batch Manager]

Wrong batch data from DRG when Batch is defined in external DB

SD-3187

[Review DRV]

End of the period is included in the request from Review values driver

SD-3184

[CSV Realtime DRV]

Duplicated records logged into the database using CSV real time values driver. Simulation project attached.

SD-3183

[Web Portal]

Combo Box doesn`t display the tag list from UHH direct driver, if a report object retrieves data from the same source

SD-3182

[DBatch]

DBatch fails to connect to the remote SQL Server

 

 

 

SD-3175

[WinCC HDA]

Slow performance of the WinCC Alarms driver.

SD-3173

[OPC UA]

No browse of items from Yokogawa OPC UA server.

SD-3169

[GENERATOR]

User that was added from Windows Active Directory and the name of the user includes capital letters doesn't see unsigned reports in e-signature console.

SD-3168

[GENERATOR]

Generator crashes when step of the Step table is batch-based

SD-3161

[OPC UA]

OPC-UA driver issues. Updated.

SD-3158

[DRV INSQL HDA ITEM]

Forward slash symbol is not treated well with WW Historian summary tags

SD-3151

[YOKOGAWA]

No Batch data from Yokogawa files

SD-3150

[DRV PCVUE HDA ALARM]

DR Studio crashes with PcVue HDS Alarms driver

SD-3149

[Citect VJH]

Alarm filter doesn't work if Alarm Text column doesn't contain any values.

SD-3147

[Batch Manager]

“Days back” option of the Batch Def. is not applied in DRG. Minor Batch Definition Improvements. Now if setting "days back" to 0 it shows all batches.

SD-3141

[Generator]

Error messages in the log file about “failed attempt to copy non-existing report file targets”. If you have only PDF, you get an error about XLS and CSV files.

SD-3139

[OPC UA RT]

Norwegian symbols are garbled with OPC-UA driver.

SD-3137

[Chart]

The line in chart is not displayed if advanced visualization is specified in the chart, and the values for chart line out of range of specified limits.

SD-3129

[Report Setting]

If remove Daily or Weekly Report generation schedule, and reopen Studio, then new timestamp 02:00:00 will be added to "Daily or Weekly Report" generation schedule

SD-3126

[InduSoft]

DR Studio crashes upon modifying Communication Drivers dialog.

SD-3123

[Generator]

In a Hot Backup mode, user can generate reports manually from RMC and Web Portal, but cannot use Action Button "Generate Report"

SD-3122

[GENERATOR]

XLSM not copied to a second location specified in the report settings

SD-3114

[S7TCP RtItem]

Record on event from Siemens S7 is not functional.

SD-3109

[STATLIB]

Stat function “Difference” returns N/A with some types of values.

SD-3108

[OPC RtAlarm]

Logger crashes upon alarm from OPC AE update.

SD-3105

[YTPCVueHDA]

Generation on event from PcVue Web Services doesn`t work

SD-3102

[CSV Alarms]

CSV Alarm driver doesn't transfer the data into Dream Report database

SD-3091

[STF]

Logged Value Counter has no result

SD-3089

[DRV WWMX RT ITEM]

Generator crashes upon start of the project

SD-3085

[DRV ODBC HDA ITEM]

Average value can’t be retrieved using Advanced ODBC driver

SD-3077

[LICENSE]

Free web client is not recognized by web portal

SD-3072

[EXCEL]

Excel report cannot be printed

SD-3070

[GENERATOR]

If an Expression containing other elements of a table Footer was created before these elements, it is not possible to retrieve these elements’ values in the report.

SD-3066

[GENERATOR]

An object which gets a footer value from a Step Table, is not calculated when used in another report

SD-3058

[DATASERVERHDA]

Setpoint Analyses functions do not work based on Data Models

SD-3049

[OPC DA]

Option to set the reconnection period if the connection fails for OPC DA driver.

 

[OTHER]

VRI (Virtual Report Instance) definition export to CSV now can be exported with a header line. General refactoring/enhancements for VRI import and export to CSV done.

 

[Report Settings]

Missing button "Add" in Select Data Item group in "Report Name Format" tab

 

[XLS Export]

Log messages with LEVEL_NORMAL level and ERROR_MSG message type

 

[STATLIB]

Calculate "diff" for different types of VARIANT.  Previously, it was calculating for VT_R8 only

 


System Requirements

  

Hardware Minimum Requirements

·  CPU:                             Dual Core 2.4 GHz+ or higher

·  RAM:                            8 Gb+

·  HDD:                            2 Gb (for installation) minimum, 7200 rpm or higher (or SSD)

·  Video adapter:              Minimum memory 128 Mb

·  Network adapter:       No special requirements

·  Monitor resolution:          1920x1080

 

   Operating Systems Supported

·  Windows Server 2012 (incl. R2), any SP, (32-bit and 64-bit editions)

·  Windows 8 Professional and Enterprise (32-bit and 64-bit editions), incl. SP1 and SP1 R2

·  Windows 8.1 Professional and Enterprise

·  Windows 10

·  Windows 10 for IoT

·  Windows Server 2016

·  Windows Server 2019

·  Windows 11

·  Windows Server 2022

Important NOTE:  With Windows 2012 users will have to install Chrome Web browser as IE 10 is no longer supported.

 

   Databases Supported

·  MS SQL Server 2005, 2008, 2012, 2014, 2016, 2017, 2019 and 2022 Express, Standard and Enterprise (using ODBC SQL Native Client 11)

·  MS Access 2000, 2003, 2007, 2010, 2013, 2016, 2019

·  MySQL 4.x and 5.x versions over ODBC driver 3.51, 5.1

·  Oracle 11, 12 over Oracle XE ODBC driver

   Validated Web Browsers Support for Web Portal

·  Chrome

·  Edge

        Important NOTE:  Browsers must support HTML5!

 

   Mobile Operating Systems

·  The AVEVA Reports Web portal is supported in a web browser on Android, iOS (both iPad and iPhone) and

Windows Phone 8.1 and 10.

 

   Additional Software Requirements

·  To visualize PDF files, Adobe® Acrobat or other PDF viewer should be installed (the latest versions are recommended). The Adobe® Reader installer is located in \ODS\AVEVA Reports\Utilities\

·  To use the Web Portal, a web server (Internet Information Server or other) must be installed before the AVEVA Reports installation. For additional information on configuring IIS for use with AVEVA Reports, please refer to the Web Portal section in Help or the tech note in the Dream Report website (https://dreamreport.atlassian.net/wiki/spaces/DreamReport/)  

·  .NET Framework 3.5 and .NET Framework 4.7.1 or higher should be installed before AVEVA Reports installation. Please note that for the successful installation of .NET 4.7.1, the latest Windows updates must be applied to the operating system

 

   Demo Version Limitations

If you have installed the AVEVA Reports Demo version (i.e., running AVEVA Reports in “Evaluation” mode, with no valid license installed,) it will have the following limitations:

·  AVEVA Reports Studio will show a yellow bar indicating that “Studio is running without a license”

·  AVEVA Reports runtime will run a project continuously for 30 minutes and then shut down.

·  A maximum of 100 unique items (tags) is allowed

·  Web portal is enabled with one concurrent web client connection

·  A red line will be added on top of each report page, which says that report has been generated with the demo version of AVEVA Reports.

·  For a full-featured trial license, please contact your local AVEVA distributor

 

  Note:

·   Please, refer to the AVEVA Reports online help to get information about any specific functionality. Online help can be opened in the Help menu of AVEVA Reports Studio (F1) or using the Windows Start > ODS > Documentation menu.

 

 

To buy AVEVA Reports for Operations

Please contact your local AVEVA distributor

 

Contact our Technical Support

[email protected]

www.dreamreport.net/techsupport