Difference between revisions of "ADempiere/Compiere JasperReports Integration HowTo"
(→ADempiere/Compiere JasperReports Integration HowTo) |
|||
Line 2: | Line 2: | ||
I'm rewriting now.... I hope to finish it soon - Thanks - [[User:Afalcone|Alejandro]] | I'm rewriting now.... I hope to finish it soon - Thanks - [[User:Afalcone|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 ''(<nowiki>http://adempiere_server:port/adempiere.jnlp</nowiki>)'' . | ||
+ | |||
+ | '''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''. | ||
+ | [[Image:JRI_Login_SuperUser.PNG|center]] | ||
+ | [[Image:JRI_Login_SystemRole.PNG|center]] | ||
+ | |||
+ | ==Create a new system Element== | ||
+ | Open the ''Element'' window from Application Dictionary > Element: | ||
+ | |||
+ | [[Image:JRI_Menu_Element.PNG|center]] | ||
+ | [[Image:JRI_FindRecord_Element.PNG|center]] | ||
+ | Click the ''New Element'' Icon | ||
+ | |||
+ | [[Image:JRI_Element.PNG|center]] | ||
+ | Fill the fields and ''Save''. | ||
+ | |||
+ | ==Database column creation== | ||
+ | |||
+ | Go to ''Table and Column'' window from Application Dictionary > Table and Column: | ||
+ | [[Image:JRI_FindTable.PNG|center]] | ||
+ | Fill the name as Process (quickly access) and press Ok button. | ||
+ | |||
+ | [[Image:JRI_Table&Column.PNG|center]] | ||
+ | |||
+ | Select ''AD_Process'' and click the ''Column'' tab | ||
+ | |||
+ | [[Image:JRI_Table&Column_Column.PNG|center|800px]] | ||
+ | |||
+ | Add a new Column and change to ''Data grid toggle''. Fill the fields as show the image. | ||
+ | 'Save'' and click ''Synchronize Column'' | ||
+ | |||
+ | [[Image:JRI_Synchronize_Confirm.PNG|center]] | ||
+ | |||
+ | Click ''OK'' and note that you have a information: ALTER TABLE….. | ||
+ | [[Image:JRI_Synchronize_ALTER.PNG|center]] | ||
+ | So it’s OK! | ||
+ | |||
+ | ==Report & Process window modification== | ||
+ | Open the ''Window, Tab & Field'' window from Application Dictionary > Window, Tab & Field. | ||
+ | |||
+ | [[Image:JRI_Menu_Window.PNG|center]] | ||
+ | [[Image:JRI_FindWindow.PNG|center]] | ||
+ | |||
+ | Fill the Name for search with Report & Process. | ||
+ | [[Image:JRI_Window.PNG|center|800px]] | ||
+ | Click on each tab until the ''Field'' tab: | ||
+ | [[Image:JRI_WindowField.PNG|center|800px]] | ||
+ | Click the ''New Record'' and change to ''Data grid toggle''. | ||
+ | [[Image:JRI_WindowFieldAdded.PNG|center|800px]] | ||
+ | Fill and ''Save''. | ||
+ | |||
+ | Ok now you have modified ADempiere. Now we will create a Process to show a sample report. |
Revision as of 07:36, 13 December 2006
The article was lost :(
I'm rewriting now.... I hope to finish it soon - Thanks - Alejandro
WORK IN PROGRESS - PLEASE DON'T MODIFY
Contents
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.
Create a new system Element
Open the Element window from Application Dictionary > Element:
Click the New Element Icon
Fill the fields and Save.
Database column creation
Go to Table and Column window from Application Dictionary > Table and Column:
Fill the name as Process (quickly access) and press Ok button.
Select AD_Process and click the Column tab
Add a new Column and change to Data grid toggle. Fill the fields as show the image. 'Save and click Synchronize Column
Click OK and note that you have a information: ALTER TABLE…..
So it’s OK!
Report & Process window modification
Open the Window, Tab & Field window from Application Dictionary > Window, Tab & Field.
Fill the Name for search with Report & Process.
Click on each tab until the Field tab:
Click the New Record and change to Data grid toggle.
Fill and Save.
Ok now you have modified ADempiere. Now we will create a Process to show a sample report.