Creating reports using JasperReports - Revision history

Mbozem at 17:27, 16 August 2026

2026-08-16T17:27:08Z

Kinerix at 05:46, 13 July 2022

2022-07-13T05:46:06Z

Schnbeck: /* See also */

2022-07-02T13:07:22Z

GeraldScott: Overview

2017-08-27T16:53:42Z

Overview

GeraldScott: Headings

2017-08-27T14:03:37Z

Headings

GeraldScott: Link to video

2017-08-27T13:25:56Z

Link to video

GeraldScott: Download

2017-08-27T13:09:36Z

Download

GeraldScott: Ed

2017-08-27T12:46:16Z

GeraldScott: Move JasperSoft Studio to its own page

2017-08-27T12:24:45Z

Move JasperSoft Studio to its own page

GeraldScott: Ed

2017-08-27T11:59:36Z

@@ Line 32: / Line 32: @@
 * Summary Fields: provides aggregate functions like sum, count, minimum, maximum, mean, variance, and standard deviation;
 * Copy Print Format: make a copy of the standard format of the ready-made reports and then change the format to suit your requirements, leaving the original print format intact.
 ==Create new reports using built-in reporting functionality==

@@ Line 60: / Line 60: @@
 [[Category: Development|P]]
 [[Category: Developer documentation‏‎]]
 [[Category: NeedsToBeUpdated]]
 [[en:Creating reports using JasperReports]]
 [[es:Crear reportes usando JasperReports]]

@@ Line 60: / Line 60: @@
 [[Category: Development|P]]
 [[Category: Developer documentation‏‎]]
+[[Category: NeedsToBeUpdated]]
 [[en:Creating reports using JasperReports]]
 [[es:Crear reportes usando JasperReports]]

← Older revision		Revision as of 16:53, 27 August 2017
Line 1:		Line 1:
		+	This is a guide to the JasperReports library that is included with iDempiere. The focus is on the standard reporting mechanism, but you can also design more complex reports using JasperSoft Studio as described [[Create reports using JasperSoft Studio\|here]].
	=Introduction=		=Introduction=
	iDempiere includes the Jaspersoft reporting software library as standard to produce reports in a simple format from many Windows, such as Business Partner Details, Bank/Cash, and so on.		iDempiere includes the Jaspersoft reporting software library as standard to produce reports in a simple format from many Windows, such as Business Partner Details, Bank/Cash, and so on.

@@ Line 1: / Line 1: @@
-==Introduction==
+=Introduction=
 iDempiere includes the Jaspersoft reporting software library as standard to produce reports in a simple format from many Windows, such as Business Partner Details, Bank/Cash, and so on.
 You can also use the embedded JasperReports engine to generate reports in your own customized format by using JasperSoft Studio to design them.
-==Standard Reporting==
+=Standard Reporting=
-===Ready-made reports===
+==Ready-made reports==
 Many iDempiere Windows include standard, ready-made tabular reports that can be generated from the Report button on the Toolbar (or type Alt-R). Some Windows, for example ''Invoices (Customer)'', also have a Print button (Alt-P) that produces a formatted page.
@@ Line 16: / Line 16: @@
 Use these ready-made reports as a guide to create your own.
-===Customise a standard report===
+==Customise a standard report==
 You can customise these reports and prints using the Toolbox icon from the print-preview window to change:
 * Add and remove columns;
@@ Line 26: / Line 26: @@
 Once you have made your changes, save the new print format and re-create the print-out.
-===Report Wizard===
+==Report Wizard==
 iDempiere also provides a Report Wizard using the Wizard icon which provides more functionality to customise the standard reports, in particular:
 * Grouping criteria: group by date or by customer, for example;
@@ Line 32: / Line 32: @@
 * Copy Print Format: make a copy of the standard format of the ready-made reports and then change the format to suit your requirements, leaving the original print format intact.
-===Create new reports using built-in reporting functionality===
+==Create new reports using built-in reporting functionality==
 You can also create your own reports using iDempiere's built-in reporting functionality by creating a Report View for a database table or a more complex database. Follow the [[Report View|guidelines here]].
-==Customised reporting==
+=Customised reporting=
-===Create new reports using JasperSoft Studio===
+==Create new reports using JasperSoft Studio==
 The standard reporting mechanism is suitable for simple reports, but using the built-in Print Format tools to customise layouts and create new reports can be cumbersome and time-consuming.
@@ Line 46: / Line 46: @@
 * [https://www.youtube.com/watch?v=B9mtzNm7CRc Short video about JasperSoft Studio].
-===JasperReports plug-in by Niemcor===
+==JasperReports plug-in by Niemcor==
 See this [http://youtu.be/JW7WmuknBUo video by Red1] demonstrating a useful JasperReports plug-in by Niemcor, with ready made sample reports. Follow the [[Plugin:_JasperReports|instructions here]].
-=See Also=
+=See also=
 * [[Making fonts available to your JasperReports]]
 * [[Finding resources in JasperReports|Making resources such as images and language files available to your JasperReports]]
@@ Line 56: / Line 56: @@
 * [http://www.adempiere.com/HOWTO_Use_Jasper_On_Financial_Reports Another link to historical Compiere documentation about Financial Reports]
 [[Category: JasperReports]]
 [[Category: Development|P]]
 [[Category: Developer documentation‏‎]]

@@ Line 39: / Line 39: @@
 The standard reporting mechanism is suitable for simple reports, but using the built-in Print Format tools to customise layouts and create new reports can be cumbersome and time-consuming.
-If you want to create more sophisticated reports and print-outs with professionally designed layouts, fonts, colours and logos, you should rather use JasperSoft Studio to do the design, then load the JRXML report definition into iDempiere.
+If you want to create more sophisticated reports and print-outs with professionally designed layouts, fonts, colours and logos, you should rather use JasperSoft Studio to do the design, then load the JRXML report definition into iDempiere for execution by the JasperReports engine.
 There is also [http://youtu.be/JW7WmuknBUo a video by Red1] demonstrating a powerful [[Plugin:_JasperReports|plug-in by Niemcor]], with ready made sample reports, that uses OSGi to install the plugin without restarting the server.