Report Engine: it is not possible to display only evacuated AML- or CEL - reports (when using SQL connector)
Summary
In the Report Engine, it is not possible to display only evacuated CEL reports when using the SQL Connector. This error has been fixed.
Description
In the Report Engine, when the SQL connector is
configured for CEL only, all CEL queries fail, regardless of whether the report
also contains AML or not. However, when
the SQL connector is configured for AML and CEL in the same database,
all CEL queries will succeed regardless of whether the report also contains AML or not.
Cause: The SQL table type for the CEL data table is read
from the wrong object, namely the AML data table. The SQL Connector for CEL therefore only works if CEL uses
the exact same SQL storage database as AML.
This behavior has been fixed. Reports can
be created for evacuated CEL or AML data only.
To
benefit from this fix:
- Update your zenon Software Platform to the latest build of zenon 11
or higher.
To apply
the fix:
- Install a build
setup containing the fix on the Reporting Studio computer.
- Start Reporting Studio and connect to the Report Engine server where the problem occurs.
- Click "Update SQL Server Extensions". The
fix is rolled out to all databases on the Report Engine server.
Item ID: 280374
Version: 12.00 Build: 232473
Version: 11.00 Build: 231258