Develop Your Own Automated SCADA Report
In previous SCADA system training, reporting module had been introduced, let’s proceed to understand on how to customize/develop a SCADA report, as it is one of the essential modules in a SCADA system.
Firstly, create a new SCADA project using Ecava IGX. Then navigate straight to Report > Archive to reveal the report table.
Add a new row to create a report, then choose “Statement” as type and “Create New File” as source.
Expand the ‘Archive’ tree to notice the new report source file had been created and added as a branch. Click on it and start to develop, create a simple report to record 2 parameters, as shown below.
Next, it is required to define 2 tags to log them into database server in order to generate the report. Click on Virtual to add 2 virtual tags, select any database from the dropdown list in “Log” column to log their values into database. In this training, the predefined simple Microsoft Access database will be used. On the right pane under Tag Attribute, user may choose when to log the particular tag, whether to log it based on timer, on change or log on both cases. For example if ‘On Timer’ was chosen, the tag value will be logged into selected database based on the chosen database’s timer (in this case database ‘mdb’ was preset to log every 5 seconds, user can change the log frequency in ‘Database’ table).
Now go back to the report source file and link those 2 tags with the report. In an Ecava IGX project, it is only needed to embed a short IGX script in the correspondent column to achieve this, refer to the following screen for example.
Lastly, it is required to define when to trigger the report in order to make it automated. There are 2 types of triggers in Ecava IGX SCADA project, which are Log Trigger and Batch Trigger.
Log Trigger refers to the one on right pane as shown in screen above, and it means the method on how user wish to trigger the logging, either by Timer or Tag. If Timer was chosen, then select any timer frequency from the list. Else if Tag was chosen, then select the particular tag. This setting will determine how each row of the report will be generated, for example if Log Trigger by timer 5 seconds, then every 5 seconds the tag’s value will be logged and a row will be appended in the report page.
Batch Trigger setting is located within the report table itself (i.e. the 5th and 6th column in the screen above). The column ‘Triggered By’ indicates the trigger method, similarly user can choose Timer or Tag, then select timer/tag from the list. It means the trigger for the report to be batched. For example, if Batch Triggered by Timer 1 minute, then every minute the report will generate a batch and the report table will be refreshed automatically. User can click on “Open” button in the report page and select any previous generated batch, as shown in screen below.
Run the Project
Click on Run Project and witness the SCADA report developed.
Note: In this training, the virtual tags values may appear static as they are not connected to any external device, user may make use of Ecava IGX Server Watch Window to change the tag value and monitor them on the report.
Indeed, one of the benefits of using Ecava IGX is the freedom of SCADA report customization. User can simply make use of CSS and HTML to create any SCADA report structure they desired. For example, in Ecava IGX Demo project, the following report page is included, and better news is that the entire Demo project folder is provided FREE all the while along with Ecava IGX installation, which means this sample report source file is included as well.
Download your copy of Ecava IGX today and enjoy the privilege of earning these sample report formats for free!