Axional Reports

Axional Reports was originally designed as a solution for the production of massive reporting in the ERP business environment and for high-quality automatic form printing. The development was first made on Informix databases and later, it was extended for use in heterogeneous environments.

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.

The query designer

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.

Report types

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 massive reporting, simply write the SQL to fetch the data and leave the rest to the engine. You only need to specify group columns and totals. There is no need to define sizes or metrics. The render will automatically accommodate font size and page orientation in accordance with the data source to produce high-quality operational PDF reports.

Page perfect forms

When data originated on an SQL access needs to be printed on a form with automatic layout, even mixing data in multi-parent and multi-detail estructures, page perfect forms are an ideal solution. The report engine will accommodate global font metrics automatically to make the form fits on a portrait or landscape PDF high quality printing document.

Page perfect documents

Page perfect documents can be considered as Page perfect forms with user metrics. Instead of leaving the system auto size the form and expand layout to acomodate destination page, user can decide font size, family and any other aspect of each field or data block. This fine tunning permits easily design documents like a purchase order or an invoice.

Pixel perfect bussines reports

Generate complex bussines reports with groups and detailed sections is often done with a GUI tool. This have many advantages but, sometimes, with the loss of control. To solve the production of automated bussines extending the previous capabilities of the report engine we introduced an XML scripting framework.

Web services integration

Once you write a report, you automatically have a web service enabled to call it from a remote system. You will be able to send the 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

Yo can use your Android™ mobile to request a report with a native client interface. This means Axional reports can be used as a fast way to mobilize your legacy applications.

Multidatabase interaction

In many cases, an organization can have multiple database systems. Having cursors iterating on two diferent databases at the same time to produce a report mixing data from diferent engines without tedious interfases can be a big advantage. Axional reports can be used on Informix, DB2, Oracle and Postgres databases at the same time, even using a common SQL grammar. You can the write any complex SQL statements using an XML SQL grammar and the system will automatically translate to the native syntax during execution.

Query performance statistics

Each query can be traced to check system performance. User inputs, rows processed and time consumed are stored allowing administrator notice where an improvement need to be done. For complex multi SQL reports a query analizer shows step by step measurements including database costs for each statement.

Document signature

The use of an electronic signature guarantees document autenticity and integrity of documents. These are key requirements for safe electronic data interchange. Depending on national laws, electronic signature can have same legal level than manual signature with the advantages of speed, security and ability to process automation.

Axional reports offers a wide set of functions to allow to sign and to verify documents, offline or during the generation phase.

Key functions

• Application of compliant signatures to PDF/A documents
• Verification of signatures in a PDF document
• Simple, advanced and qualified electronic signatures
• Long-term signatures with embedded trust chain, time stamp and verification information on certificate validity
• Support for mass signature devices (HSM) via PKCS#11
• Author’s signature (MDP)
• Invisible and visible signatures and design functions for visible signatures

Encryption

• Protect PDF files against unauthorized access
• Encrypt and decrypt PDF documents with owner and user passwords
• Set document permission flags:
  • Read
  • Print
  • Extract
  • Annotate, sign
  • Change
• Set encryption filters (none, RC4, AES)
• Set encryption key length (40… 128 bit)
• Use timestamp servers

This post/page is also available in: French, German, Spanish, Catalan