Product Line
Power Monitoring Expert 2020
Power Monitoring Expert 2021
_____________________________________________________________
Environment
Web Application - Report - Hourly Usage Report
_____________________________________________________________
Issue
Timestamps are shifted by +1 hour in the Hourly Usage Report.
In PME 9.0, in the below image, the timestamp is correct:
In PME 2020, in the below image, the timestamp is shifted by 1 hour:
_____________________________________________________________
Root Cause
The report is treating the data as interval end instead of interval beginning.
_____________________________________________________________
Proposed Solution
1) Make a copy of the Hourly Usage Report.rdlc located at %\Power Monitoring Expert\web\ReportDepot\ION Reports\ION Report Packs\Default Reports
2) Open the original rdlc file with a XML editor (Notepad, Notepad++, etc).
3) Crtl+F to find "DateAdd" string
4) Edit lines 1457 and 1459, changing respectively 59 and 60 to -1 both.
5) Save the file and run the report again
_____________________________________________________________
Additional Notes
This issue has affected PME 2020 and PME 2021.
Although the resolution above is applicable for both versions, an official hotfix will be provided for PME 2021 and added to this article when available.