Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Reports in the PROMOTIC system

Depending on the content requirements and the presentation format, it is necessary to choose a suitable technology for making such documents.
 
In the PROMOTIC system it is possible to use following technologies for report design HTML, e-mail, Excel, Libre Office, PDF etc.

The PROMOTIC system can also cooperate or provide data to specialized report design software solutions (e.g. Crystal Report).

 

PmaReport

Uses the HTML technology. The document contains keywords that are replaced by current values from PROMOTIC application once the report is opened. It allows to display individual values, arrays of values in table form or as images.
 
Advantages:
- The system includes simple template preconfigurations of system data reports.
 
Disadvantages:
- HTML and syntax knowledge is required for HTML report template design.
 
See: Preconfigurations in group "Report (PmaReport)", Report examples

PmaPanel - Print panel into the PDF file

In the PROMOTIC application it is possible to print by sending the data to a virtual printer (OS Windows 10 contains "Microsoft Print to PDF") that does not print on a paper but into the file. In OS Windows 8, 7 and older systems it is necessary to install another third party software.
 
Print panel with printer selection:
JavaScriptVBScriptSelect and copy to clipboard

pMe.Root.Print("");
 
Advantages:
- Simple, user controlled usage of panel printing method.
 
Disadvantages:
- If called on a panel that is not currently open then its content may be incomplete (missing trend curves, empty tables, etc.).
 
See: Print the open panel (or its part) to a printer or into the file, Print the panel (or its part) to a printer or into the file, How to print in the PROMOTIC system

Microsoft Excel

Allows writing data into Microsoft Excel documents by PmaAdo or by VBA technology.
 
Advantages:
- Allows easy automated creation of reports.
- Data from PROMOTIC application can be then presented by Excel graphic features.
- Excel (since version 2007) allows own method for saving the resulting report into PDF file.
 
Disadvantages:
- Installation of 32-bit version of Microsoft Office on the target PC is required
 
See: Excel database, Examples of usage the Excel database in the PROMOTIC system, Examples of the work with applications excel, Examples of the work with applications excel

LibreOffice Calc

Can use the LibreOffice API technology to write data into Calc documents.
 
Advantages:
- Allows easy automated creation of reports.
- Data from PROMOTIC application can be then presented by Calc graphic features.
- Libre Office can be downloaded and installed free of charge.
 
Disadvantages:
- Installation of Libre Office on the target PC is required
 
See: Calc database

SAP - Crystal Reports

Crystal Reports is a development tool that allows to create complex database queries and present graphical results. The reporting process itself does not require knowledge of the SQL language, although it is possible to create queries using this language.

This program allows to create links between tables, select and group records, contains a rich set of options to hide unnecessary records, supports filtering based on user-defined formulas that improve data visualization capabilities.

 
Advantages:
- Designed for corporate analytics
- Easy report design by drag&drop
 
Disadvantages:
- Purchase of licence is required.
- VBScript cannot be used to run Crystal Reports 2016 as you could in earlier versions.
- Crystal Reports 2016 (crw32.exe) does not accept command-line arguments.
 
See also:
- PmaReport (object)
PROMOTIC 9.0.15 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice