Create reports using JasperSoft Studio

This guide explains how to use JasperSoft Studio to create complex reports and print-outs for use by the JasperReports engine embedded in iDempiere.

Introduction

The standard reporting mechanism is suitable for simple reports, but creating complex reports with sophisticated layouts can be difficult and time-consuming using the built-in Print Format tools.

Use JasperSoft Studio to do the design of sophisticated reports and print-outs with professionally designed layouts, fonts, colours and logos, then load the JRXML report definition into iDempiere for execution by the JasperReports engine.

How to do it

Install JasperSoft Studio

• Download and install the Community Edition of JasperSoft Studio from the download page (note: don't download the older iReport Designer as this has been deprecated in favour of JasperSoft Studio);
• Follow the installation instructions here. JasperSoft Studio is built on the same framework as the Eclipse IDE so the installation and usage is the same.

Create a report

Data Adapter

• Start up JasperSoft Studio;
• Delete the two unnecessary Data Adapters (called One Empty Record and Sample DB);
• Create a new Data Adapter to connect to the iDempiere database: Create Data Adapter > Database JDBC Connection > Next >
  • Name: iDempiere Data Adapter
  • JDBC Driver: org.postgresql.Driver
  • JDBC URL: jdbc:postgresql://localhost:5432/idempiere (use localhost if the database is on the same machine as JasperSoft Studio, otherwise replace localhost with the name of the database server);
  • Username: adempiere (the same username that was used when iDempiere was installed)
  • Password: *********
• Click on Test to test the connection parameters;
• Click Finish if all is well.