Create reports using JasperSoft Studio
From iDempiere en
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 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.
Create JasperReport
