Promotic

Preconfiguration "PmaReport - Reports of trend data based on defined filtering criteria"

This preconfiguration can be activated when creating a new object (e.g. by "New object ..." in the local object menu or by pressing the Insert key after selecting the object) and is included in the group: "/ Reports / Report Alarms and Trends".
This preconfiguration can be created in the object: PmaFolder or PmaRoot.
The preconfiguration is created including the panel (object of the PmaPanel type) is functional also as Web panel.

The preconfiguration creates an object of the PmaFolder type that contains PmaSequencer subobjects, PanelReport panel and Report subobject (PmaWebDir) and FileBrowser (PmaPanel). The functionality of these objects:
Seq - in the onStep event the data is processed based on criteria defined in the panel and at the same time forms the content of the HTML page with the report table
PanelReport - contains methods that allow searching for trend objects in the application, loading and saving the configuration into csv file, or launching the sequencer with input parameter.
Subobject Report offers this finished HTML page for display in the PmgFrame object.


Graphic objects in the image are visually vertically separated.
The left part contains the PmgFrame object in which the auxiliary PmgForm with information or the resulting HTML report can be displayed..
In the right part there are objects that can logically create the data necessary for entering the input parameters. The result will be processed data and displayed in the table in the left part of the panel.

The input parameters for data processing into the report are:
Name - Title of resulting report
Enter start time - Calendar for selection of the beginning time of processed data
For time range - There are two entries that define the length of the period for data processing, e.g. 7 days.
Time ranges for calculation - Defines the time range in which the data is recalculated based on the selected filter, e.g. one hour (this entry represents each data row in the table)
Source data, filter type - Represents a table with functional buttons that define the trend to be processed in the report. The window for adding or editing contains following items: Group of trends, Trend (id), Unit, Conversion mode and Trend user defined name (of column) (represent one column of the table). The configuration of the table can be saved into a named file for further usage.
Page orientation - Switches to page print view
The result in on the last row - displays the last row with total recalculation of values.


After pressing the Show report button, a method is started that processes the necessary parameters and sends them on for processing in the in the application. At the same time, timing is activated, which allows you to monitor the processing progress in percentage and finally display the report itself.

The HTML page with the resulting report has two buttons that allow to print the report or save it to a CSV file
These configurators can be set before the preconfiguration is created:
The name of created objectName of the object created in the Pma objects tree. The maximum name length is 30 characters. This is a system name, so it must contain only alphanumeric and must not contain any diacritics (i.e. national dependent characters), empty string, spaces and the first character must not be a number.
Default: "Reports"
Enable as Web componentSpecifies whether this object has to be registered as a Web server component
After the preconfiguration is created, the "PmaPanel > Web server > Enable as Web component" configurator will be set to this value.
PmaWeb objectPath in the Pma objects tree to the object PmaWeb, PmaWebFolder or PmaWebLang where the registration is carried out.
Macro expression can be used for input (it is evaluated after the application is launched).
After the preconfiguration is created, the "PmaPanel > Web server > PmaWeb object" configurator will be set to this value.

History:
Pm8.03.25: Created
Pm9.00.23: Changed concept of HTML report rendering (by means of the PmaWebDir object).
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.