HOWTO Use Jasper On Financial Reports

From AdempiereWiki

Jump to: navigation, search

Applicable for versions > 3.3.1b

Now you can use Jasper Reports in order to format the financial reports - and apply all the power of Jasper (formulas, grouping, etc).

You may also find interesting JasperReports Integration HowTo

Define the Process

You simply need to define a new system process pointing to your jasper file:

Image:01_jasperbalance.png

You don't need to define parameters for the process.

Define the Financial Report

Then you can use the defined jasper process in the financial report

Image:02_jasperbalance.png

Jasper Report templates

You can download and use the next provided report as template to construct your own reports: T_ReportTemplate by Carlos Ruiz.

An example of more complex, cascading Jasper report by Mario Calderon is found here: Example of complex Jasper Report.


How to deploy your Jasper Reports on an own directory (by Mario Calderon):

  • download the following file; Own JR deployment.
  • decompress zip file.
  • save a copy of "trunk/JasperReportsWebApp/build.xml".
  • copy the decompressed zip file into "trunk/JasperReportsWebApp".
  • define an ant in Eclipse pointing to "trunk/JasperReportsWebApp/build.xml".
  • copy your jrxml and jasper files into "trunk/JasperReportsWebApp/shwReportVerzeichnis".
  • execute the ant command "shw-packaging"
  • ant creates 2 files: "shwReports.ear" and "shwReports.war". You can check their contents with ark or a similar tool.
  • copy shwReports.ear into $ADEMPIERE_HOME/jboss/server/adempiere/deploy
  • JBoss will deploy the files into a temporary directory at startup and delete the temporary directory at shutdown.
  • This way, you can define your reports in the "Report&Process" window, Field "Jasper Report" (see above) the following way: http://192.168.1.100/shw/my_report.jasper o http://my-named-server/shw/my_report.jasper.

The JRs are thus accessible by all clients (windows or linux).


A simple financial jasper report by Colin Rooney is found here: Example of financial Jasper Report.

Personal tools