Reporting

The NETx BMS Platform provides a tool for both built-in and custom reports. It is comprised by the following components:

  • Reporting web manager app: The user interface in the Web Manager. It allows to generate reports instantaneously, to set up report templates that can be triggered by the scheduler, and to modify reports or even design new ones.

  • Reporting app: An extension to the Core Server that handles generating of the output document and licensing.

Available as an extension, the package is installed during regular setup installation and can be updated through the Extension Manager.

Configuration

Interface is available for the following products: 

  • NETx BMS Platform

Changelog

Version

Date

Notes

Version

Date

Notes

2023.12.14

Dec 14, 2023

Fixes

  • Concurrent report generation may result in one single file – fixed.

2023.8.28

Sep 21, 2023

New features

  • New report “Metering Table”

Fixes

  • Metering chart report: option “Label” is not considered – fixed.

  • Metering table report: table rows appear in random order – fixed.

2023.5.11

May 17, 2023

Fixes

  • Report [Default] Metering Chart cannot be executed – fixed.

  • Report [Default] Trending Table Multi: first character of trending names are missing – fixed.

  • Reports show time without am / pm – fixed.

  • Report [Default] Trending Chart Plot: report cannot be executed – fixed.

2023.2.21

Mar 29, 2023

Fixes

  • Unable to use custom database name – fixed.

  • Report "Alarms active over a period" shows time range in UTC instead of local time – fixed.

  • Report "Alarms active over a period" does not indicate "no data" if no data is available – fixed.

  • Warning log on alarm messages – remove.

2022.11.10

Dec 15, 2022

Fixes

  • XDB.Hostname and XDB.Port was handled as mandatory although it shall be optional – fixed.

2022.10.10

Oct 13, 2022

New features

  • New datasource type to include server items in reports.

  • New custom functions to be used in reports:

    • GetItemValue

    • GetItemPropertyValue

    • GetEventPropertyValue

    • ToLocalDateTime

  • New reports:

    • Alarms currently active

    • Alarms active over period

    • Alarms Multi

Improvements

  • Trending Chart Plot report: label and decimals settings of trendings are now considered.

  • Trending Chart report: Aggregation is now an option.

  • Report generation is now limited by system configuration parameter XDB.LongCommandTimeout.

  • General refinements of reports.

Fixes

  • Report execution fails on non-English systems – fixed.

1.1.13

Jun 2, 2022

Improvements

  • Internal changes, required for BMS Platform R2 Build 2060+.

1.1.12

Mar 31, 2022

Improvements

  • Minor internal improvements.

1.1.11

Nov 11, 2021 

New features

  • Trending Table Multi report.

Improvements

  • LaMPS reports were moved from the Reporting extension to the LaMPS extension.

Fixes

  • Missing translations for report parameters – fixed.

1.1.10

Jul 20, 2021 

Fixes

  • XCommand REPORTING.SENDREPORT does not attach report – fixed.

  • Race condition prevents report from being saved in correct folder – fixed.

  • Report parameter "Gateway path" cannot be selected from item tree – fixed.

1.1.9

May 18, 2021 

New features

  • New report for Metering Calculation chart elements.

  • New report for plots of Trending Chart elements.

  • New report for plots of all Trendings starting from a given folder in the project tree.

Improvements

  • Delete status of DALI gateways and devices is considered in following reports:

    • Emergency Lighting Status

    • Emergency Lighting Status Multi

    • Gateway

    • Group

    • Logbook

    • Logbook Multi

    • Test Log

Fixes

  • Generated report is saved in a wrong location in the file system – fixed.

  • Trending chart report: Possible wrong data display in week view – fixed.

1.1.8

Mar 4, 2021 

Improvements

  • Default reports include report metadata.

  • Default Alarm report: include priority and status change reasons.

Fixes

  • During initial start of the reporting server after installation, a warning regarding a missing certificate is logged – fixed.

  • Report designer: Preview does not prompt for report parameters – fixed.

  • Report designer: Query builder does not show SQL table columns – fixed.

  • Possible loss of reports when created in close temporal proximity – fixed.

  • LaMPS Gateway and Group reports: No pages if no test results are present – fixed.

  • Meter Point consumption report: Yearly view does not handle daylight saving time properly – fixed.

  • Trending Chart report: Mis-aligned binning in day view – fixed.

  • Trending Chart report: Dynamic time axis can lead to malformed output – fixed.

1.1.7

Nov 2, 2020 

Fixes

  • Meter consumption reports do not consider daylight saving time – fixed.

1.1.6

May 11, 2020 

  • Meter consumption reports: internal changes.

1.1.5

Apr 22, 2020 

minor internal improvements

1.1.4

Mar 19, 2020 

  • New LaMPS reports which address multiple gateways in a single report.

  • Improved readability of time-axis in chart reports.

  • Designer: Saving a report leaves the report's reference to the data source unusable – fixed.

  • Deleted reports are still shown in the selection – fixed.

1.1.3

Jan 20, 2020 

(internal release)

1.1.2

Sep 17, 2019 

  • LaMPS Emergency Lighting Status Report / detail of duration test is possibly wrong – fixed.

1.1.1

Sep 11, 2019 

  • LaMPS Emergency Lighting Status Report / detail of function test is possibly wrong – fixed.

  • LaMPS Emergency Lighting Logbook Report / no test results shown when test was triggered on device level or higher – fixed.

  • Excel reports show timestamps in UTC – fixed.

1.1.0

Jul 26, 2019

  • Reporting server does stop when Core Server stops – fixed.

1.0.6

Jun 6, 2019

  • Emergency Lighting Test Result / missing scaling of result value in reports – fixed.

1.0.5

May 29, 2019

  • Report designer / query builder not working – fixed.

  • LaMPS Emergency Lighting Status Report / styling improved.