ADempiere/Compiere JasperReports Integration HowTo

From ADempiere
Revision as of 07:36, 13 December 2006 by Afalcone (Talk) (ADempiere/Compiere JasperReports Integration HowTo)

Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

The article was lost :(

I'm rewriting now.... I hope to finish it soon - Thanks - Alejandro


WORK IN PROGRESS - PLEASE DON'T MODIFY

Overview

TODO

Preparing ADempiere

The first step that you need is add some field for store the filename of your report, then you will be able to add process for your report and fill the name for each one.

Then come on, start with it!

Start ADempiere

Start ADempiere as with the Java Web Start method (http://adempiere_server:port/adempiere.jnlp) .

Note: You might need a JDK version not a JRE in order to compile the Report.

Login

Login as SuperUser with the System Administrator Role.

JRI Login SuperUser.PNG
JRI Login SystemRole.PNG

Create a new system Element

Open the Element window from Application Dictionary > Element:

JRI Menu Element.PNG
JRI FindRecord Element.PNG

Click the New Element Icon

JRI Element.PNG

Fill the fields and Save.

Database column creation

Go to Table and Column window from Application Dictionary > Table and Column:

JRI FindTable.PNG

Fill the name as Process (quickly access) and press Ok button.

JRI Table&Column.PNG

Select AD_Process and click the Column tab

JRI Table&Column Column.PNG

Add a new Column and change to Data grid toggle. Fill the fields as show the image. 'Save and click Synchronize Column

JRI Synchronize Confirm.PNG

Click OK and note that you have a information: ALTER TABLE…..

JRI Synchronize ALTER.PNG

So it’s OK!

Report & Process window modification

Open the Window, Tab & Field window from Application Dictionary > Window, Tab & Field.

JRI Menu Window.PNG
JRI FindWindow.PNG

Fill the Name for search with Report & Process.

JRI Window.PNG

Click on each tab until the Field tab:

JRI WindowField.PNG

Click the New Record and change to Data grid toggle.

JRI WindowFieldAdded.PNG

Fill and Save.

Ok now you have modified ADempiere. Now we will create a Process to show a sample report.