Custom Report in Adempiere
Alphamedia Consulting

Custom Report in Adempiere



The one that makes the process easier reporting in Adempiere is the facility to Customize reports in accordance with what we want. Adempiere allows you to customize your report and customize it to your needs. With this facility you can make the appropriate report forms that are typically seen by the user, such as the Indonesian-style report format.
In the report, you can change the following elements:
• Display Order
• Sort Order
• Format Item

- Field, Image, Text, Print Format
- Alignment% Width / Height
- Calculate Sum – Average – Count
- Group by (requires Order by sorting)






Print format

Open the Print Format window to customize your report by clicking on the General Rules, or alternatively click on the Print button on the toolbar Customize Report on the Report.
Note : When you open the Print format using the menu option you have to close and reopen your report to see the changes that have been made ​​. If you open the Print Format Report reports using the Customize button you will be shown again with the changes that you have made when you close the Print Format .You see the Report Name , That in accordance with the table where the field is located .Reports indicate the field of view is the view that is used to produce this report .

Remove checkbox option on the Form to print a columnar List Report ( Register columnar report ) . Tick ​​was to print a form . Customizing The format will be discussed in the next section , Customizing Format . A format having individual elements with spatial information ( eg, invoices , checks ) . A columnar list report having individual columns ( example : a list or inventory invoice lines) .

Print Table Format determines the Fonts , Colors of the table are in print .

Check the Standard Header / Footer checkbox to show the standard of the Header and Footer are used . If you do not want to use the standard header , must be explicitly defined .

Print Paper Size illustrate , Orientation and Margins ( edge lines ) about the document .

Print Fonts Fonts are used to print . Print Color is the color to use for printing .

Button Copy / Create allows you to copy a print format or create a new Print Format of a Table .

Display Order
Change to the tab order to change the display order of the elements in the report and tailored to your needs:
To add an element into the report, click on the various options available list and move them to the list order by clicking the arrow on the right side.To change the order of an element by using the selection arrows up / down. To remove an element from select Reports and click on the arrow to the left. Save your changes. The changes will take effect immediately on your next statement.Move to the Sort Order tab to change the order of the order and adjust it to your needs:
In addition you can also set the format of the report, adding logo / Text, set the location of the fields and others, who will try to be discussed later.
Jasper Reports
If the facility is in a custom report that Adempiere is still not enough, you can use custom reports using Jasper Reports. By using Jasper Reports reports you can create more complex designs, such as for accounting and taxation Indonesia. To help design the report would normally use another utility assistance, for example iReports.
Hopefully next time I’ll try to write about creating reports using Jasper Reports and iReport.
Agung Budi Santosa
Jakarta – Indonesia