Skip to main content

python report generator engine to process JasperReports jrxml file.

Project description


Pure Python engine to generate reports from JasperReports jrxml file.


AgateReports is a pure Python tool to generate reports without extensive coding. It currently relies on Jaspersoft Studio to graphically position reporting elements on a report layout.


This package aims to be a solution to following users:

  • Python developers who want to create a report using GUI tool.

  • Users who want to modify existing reports without programming.

Differences with JasperReports

  • AgateReports use different components than JasperReports and there are minor differences. AgateReports components are based on modules such as ReportLab that are available in Python

  • AgateReports ia able to use .ttc fonts

  • Additional components available in Python are added. Currently, jrxml file must manually be edited to use these components. Furthermore, since JasperReports do not support these components, edited jrxml file can no longer be edited with Jaspersoft Studio. There is a plan to fork Jaspersoft Studio to support Python language syntax and these components.

Current Restrictions

  • AgateReports is still in initial development phase and does not provide all of JasperReports features.

  • Patterns, format, and Java classes specified in jrxml file need to be changed to Python equivalent. For example, “Current Date” needs to be converted from “new java.util.Date()” to “”

  • Currently, only MySQL, Postgresql, and csv file are supported as a datasource

  • Performance is slow for large data source.


Python3.6 or above ReportLab Pillow MySQL Connector/Python psycopg2


AgateReports requires Pillow. If Pillow is not already installed, please install it with the following command.

pip install Pillow

AgateReports can be installed by the following command:

pip install agatereports

Getting Started

Please refer to the following github project for full documentation.

demos directory contains samples of jrxml files and Python scripts on how to use AgateReports.

Usage Sample

from agatereports.adapters import MysqlAdapter
from agatereports.basic_report import BasicReport

import logging
logger = logging.getLogger(__name__)

def datasource_mysql_sample():
    MySQL data source sample.

    WARNING: Before running this sample, schema 'agatereports' must be create and populated.
    Run scripts in directory 'agatereports/tests/database/mysql' to create and populated database tables.

    CAUTION: Edit values of 'host' and 'port' to those in your environment.
     """'running datasource mysql sample')
    jrxml_filename = '../demos/jrxml/datasource_mysql.jrxml'  # input jrxml filename
    output_filename = '../demos/output/datasource_mysql.pdf'  # output pdf filename

    # MySQL datasource
    config = {'host': 'localhost', 'port': '3306', 'user': 'python', 'password': 'python', 'database': 'agatereports'}
    data_source = MysqlAdapter(**config)

    pdf_page = BasicReport(jrxml_filename=jrxml_filename, output_filename=output_filename, data_source=data_source)

if __name__ == '__main__':


Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

agatereports-0.0.1.tar.gz (28.3 kB view hashes)

Uploaded Source

Built Distribution

agatereports-0.0.1-py3-none-any.whl (47.9 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page