XSQUARE REPORTS

Develop reports as you are used to!

Design templates of printed forms directly in familiar MS Office/ My Office, P7 office. No additional print form designer needed

The advantages of using XREPORTS

  • Development requirements

    • REST API (xml/json)
    • 1 command to install - yum install xreports
    • 5 parameters to set up
    • 10 minutes for the first report to be ready

  • Environment requirements

    • Native generation XLSx, DOCx, PDF. Independence from frameworks and libraries
    • 15 MB RAM to work with 10 users HTTP clients
    • Any RPM/DEB based operating system
    • Any architecture - X86/ARM/Elbrus/Baikal/Loongson

  • Launch Requirements

    • 10 000 reports per minute in competitive mode
    • 1 million XLSx lines in 15 seconds
    • Bulk document printing
    • Native parsing XLSX
    • Merging PDF documents

XLSx generation speed:

  • 0.129 seconds
    10k lines
  • 1.3 seconds
    100k lines
  • 15 seconds
    1 mln lines

Architecture of the XREPORTS solution

  • HTTP BY
    {JSON}
    <XML>
  • XSQUARE-REPORTS SERVER
    FAX
    Template set
  • READY DOCUMENTS

Login and Try It

Demo

More details

Documentation

More details

Download

More details

The platform provides

  • Familiar environment

    Design templates of printed forms directly in familiar MS Office/ My Office, P7 office. No additional print form designer needed

  • Flexibility

    Using unified requests in the JSON or XML format allows to use any data sources for the requests

  • Speed

    The report server allows to process multiple client requests in parallel and quickly generate reports

  • Easy integration

    Using REST API allows to easily integrate the report server into any IT- system

  • Cross-platform compatibility

    The report server supports x86-64/ARM/E2K/Loongson

  • Autonomy

    The report server is independent from third-party libraries and Open Source libraries, it is 100% in-house developed.

  • Versatility

    The report server supports all popular document formats: DOCX, XLSX, PDF

  • Functionality

    The report server also provides additional functionality: bulk printing of documents, data export from XLSX documents, forming a printed PDF form, merging PDF documents

  • We can do this:

    select * from XLSx.Sheet1 Can you?

Report generation process

  • Create a document template in a familiar format.

    Edit templates wherever you want: WORD / EXCEL / P7 Office/ My Office / Libre Office

    You can generate pixel-by-pixel layout of PDF documents using PDF generator commands.

    1 generation stage

  • Create a request in a unified format in JSON or XML files. This allows the source of data to populate templates to be your database, web pages, web forms, or third-party services.

    Using a single report server allows you to unify all documents in your organization.

    2 generation stage

  • As a result, the service will generate a ready document in the required format: DOCX, XLSX, PDF, CSV, etc.

    Preparing a template takes a couple of minutes and can be edited at any time without involving developers.

    Result

The Report Server is:

The service of report generation from a template document in DOCX format by HTTP-request in JSON or XML format

Functionality:

  • parsing DOCX files;
  • replacing tags in a template with substitution data from the request;
  • generation of lists based on request data;
  • generation of tables based on data from the request;
  • conditional expressions - inclusion/exclusion of document parts depending on the parameters in the request;
  • replacing images in a template with substitution data from the request;
  • generation of bar codes and QR codes;
  • multiple generation of data blocks based on the block template and data from the request;
  • generation of multiple reports based on one template and multiple input data;
  • saving the resulting report in DOCX or PDF format;

The service of report generation from a template document in XLSX format by HTTP-request in JSON or XML format

The service of data export from XLSX documents to JSON, XML, CSV formats

The service of generating PDF reports by HTTP-request in JSON format

The service of merging PDF documents by HTTP-request in JSON format

The service of forming a printed form from a PDF document by HTTP-request in JSON format

Runtime environment

Hardware:

RAM - 20Mb

CPU - 1 Core

HDD - 50Mb

Operating systems:

Compatible with

  • Astra Linux
  • RED OS
  • Alt Linux
  • ROSA

Any rpm/deb based OS

  • Ubuntu 20+
  • Red Hat 8+
  • Debian 10+

Architectures:

  • x86-64
  • ARM (including Baikal)
  • e2k Elbrus