- 1 Query Designer
- 2 Report Types
- 3 Android™ Mobile Integration
- 4 Multi-Database Interaction
- 5 Query Performance Statistics
- 6 Document Signature
The report engine produces four categories of reports and includes electronic signature capabilities, mail integration, and strong database integration. It also includes batch scripting capabilities to support crontab-style scheduling.
Before launching a report, users usually need to restrict the data set. With a flexible Query by Example (QBE) form builder, you can design forms that make it easy for users to select the range of data to be printed. Traditional QBEs are extended to include variable selection, including single-choice and multi-choice combos.
The report engine is designed to deal with four types of reporting methods, covering the most common types of business needs.
Pixel Perfect Operational Reports
For mass reporting, simply write SQL to fetch the data and leave the rest to the engine. Users only need to specify group columns and totals; there is no need to define sizes or metrics. The renderer will automatically accommodate font size and page orientation in accordance with the data source, thus producing high-quality operational PDF reports.
Page Perfect Forms
When data which originated in Access SQL must be printed in a form with automatized layout, even mixing data in multi-parent and multi-detail structures, Page Perfect forms are the ideal solution. The report engine will automatically accommodate global font metrics to make the form fit on a high-quality portrait or landscape PDF for printing.
Page Perfect Documents
Page Perfect documents can be considered Page Perfect forms with user metrics. Instead of allowing the system to autosize the form and expand layout to accommodate the destination page, the user can decide font size, family and any other aspect of each field or data block. This fine-tuning simplifies the design of documents such as purchase orders or invoices.
Pixel Perfect Business Reports
Generating complex business reports, with groups and detailed sections, is often done with a GUI tool. This method has many advantages, but often entails a loss of control. To resolve these automated report production issues, extending the previous capabilities of the report engine, we introduced an XML scripting framework.
Web Service Integration
Once a user writes a report, web service is automatically enabled to call it from a remote system. You will be able to send query restrictions and request the response in raw XML, PDF, CSV, or Excel. This makes Axional Reports easy to integrate with your currently-existing applications.
Android™ Mobile Integration
With their Android™ devices, users can request a report with a native client interface. This means that Axional Reports can serve as a quick way to convert your legacy applications to mobile.
In many cases, an organization may possess multiple database systems. Having cursors iterating on two different databases at once, thus producing a report mixing data from different engines without tedious interfaces, can give your company a notable advantage. Axional Reports can be used on Informix, DB2, Oracle and Postgres databases simultaneously, even using a common SQL syntax. You can then write any complex SQL statements using XML SQL syntax, and the system will automatically translate to native syntax during execution.
Query Performance Statistics
Any query can be traced to check system performance. User inputs, rows processed, and time consumed are all stored, and administrators gain knowledge of where improvements are needed. For complex multi-SQL reports, a query analyzer shows step-by-step measurements, including database costs for each statement.
The use of electronic signatures guarantees document authenticity and integrity. These are key requirements for safe electronic data exchange. Depending on national laws, electronic signatures can have the same legal status as manual signatures, with the additional advantages of speed, security, and automatic processing.
Axional Reports offers a wide set of functions to allow document signature and verification, whether offline or during the generation phase.
- Application of compliant signatures to PDF/A documents.
- Verification of signatures in PDF documents.
- Simple, advanced and qualified electronic signatures.
- Long-term signatures with embedded trust chains, timestamps and verification information on certificate validity.
- Support for mass signature devices (HSM) via PKCS#11.
- Author signature (MDP).
- Invisible and visible signatures, with design functions for visible signatures.
- Protect PDF files against unauthorized access.
- Encrypt and decrypt PDF documents with owner and user passwords.
- Set document permission flags:
- Set encryption filters (none, RC4, AES).
- Set encryption key length (40… 128 bit).
- Use timestamp servers.