ProReports is simple reporting system designed to generate reports in popular office formats – PDF, XLS, RTF, HTML, TXT, XML, JSON, CSV, PNG, GIF. User can prepare report in internal format of ProReports (simple Visual Programming Language mixed with PHP5 and JAVA). This give him very high flexibility because in this format there are almost no limits and this is the true power of this simple system. To the system we can attach own plug-ins written in PHP5 or JAVA. System is rather framework for programming reports (and not only – is a good tool for building REST API microservices) than drag&drop tool.
The system can work great with our SrvSKP communication server by downloading data from the database and generating input for the communication sensor, e.g. in the form of XML, which is then sent to other systems/databases.
Features
- multiple SQL queries in one report,
- multiple datasource in one report,
- support for temporary tables,
- support for stored procedures (PL/SPL),
- execute not SELECT sql command,
- multilingualism (UTF-8 support) in reports,
- multiplatform (AIX, Linux, Solaris, Windows)
- support reports based on RTF templates,
- support for popular formats (PDF, XLS, RTF, HTML, TXT, XML, JSON, CSV, PNG, GIF),
- digitally signed PDF reports,
- support for multiple databases,
- dashboards for managers,
- ability to extend the functionality by adding modules PHP5 and JAVA,
- access to the reports by the browser WWW,
- internal schedule generation of reports,
- module for automatically send reports (e-mail) with GPG encryption, ZIP compression,
- connection pooling for databases,
- ability to generate reports from the command line (windows and unix),
- possibility of mass generation and processing of reports,
- definable forms for parameters of reports,
- support for permissions to reports,
- data filters to generate reports,
- multithreaded execution of SQL queries,
- tool for building REST API microservices.