Wikiadmin: Created page with "== Objetive == The goal of this how to is to describe the steps required to create a new report in Openbravo 3. The example explained is a simple report with a list of product..."

2018-10-15T13:43:23Z

Created page with "== Objetive == The goal of this how to is to describe the steps required to create a new report in Openbravo 3. The example explained is a simple report with a list of product..."

New page

== Objetive ==
The goal of this how to is to describe the steps required to create a new report in Openbravo 3. The example explained is a simple report with a list of products.

== Acknowledgments ==
Before starting make sure that you have read the [[Prerequisite Knowledge|prerequisite knowledge]] article. And you are confident with Openbravo [[Modularity_Concepts|modularity concepts]]

== Setting up Jaspersoft Studio ==

{{(!)| Jaspersoft Studio design client is supported since '''3.0PR15Q3'''. For older releases check [[#Creating_a_Reports_in_old_releases|this section]].}}

You need to download Jaspersoft Studio, a graphical tool that allows you create and modify JasperReports templates (.jrxml files).
* Download [https://sourceforge.net/projects/jasperstudio/files/JaspersoftStudio-6.0.0/ Jaspersoft Studio] version '''6.0.0''' (v6.0.0). If using a higher version then it is necessary to ensure that the reports are generated for the '''JasperReport 6.0.0''' version. More info can be found [https://community.jaspersoft.com/wiki/compile-older-jasperreports-version-jaspersoft-studio here].
* On Linux: just download the .tgz file and uncompress it, execute the binary Jaspersoft Studio located inside the main folder
* On Windows: Download and execute the .exe file

=== Configuring Jaspersoft Studio===
Some properties of Jaspersoft Studio need to be modified in order to work properly. In short, you need to make sure:
* You modified the JasperReport property ''net.sf.jasperreports.awt.ignore.missing.font'' and set it to '''true'''
* '''Not''' use any '''Scriplet''' class
* Use '''Java''' as default expression language

{{(!)| Jasperreport can be used in hw manager, but the version should be 1.0.2801 or higher}}

=== Setting up Classpath ===
In Jaspersoft Studio, each report is supposed to be part of a project. So, you first need to create a new project (''File > New > Project'').

The project has a classpath, and here is where you can add the jars you need.

* Right-click on the project name: ''Properties > Java Build Path''
* Move to '''Libraries''' tab
* Click '''Add External Jars''' button
* Add the desired library.
* Click '''OK'''

== Creating the Template ==
* Go to '''File''' > '''New'''
* Pick '''Jasper Report'''
* The '''New Report Wizard''' will be opened
[[Image:NewReportWizard.png|400px|thumb|center]]
* Select a Report Template, (Blank following our example)
* Define a Report Name
* Define the file Location in the project.

Later on we will copy this .jrxml file inside our Openbravo module that is going to keep our Report and the required configuration in the Application Dictionary also.

* Define the Report Data Source: by clicking on "New", a new database connection can be configured using the '''Data Adapter Wizard'''
* Click '''New'''
* Pick '''Database JDBC Connection''' and click ''Next''
* Fill all the fields
** '''Name:''' openbravo (or any name you like, e.g. pi)
** '''JDBC Driver:''' PostgreSQL (org.postgresql.Driver). In this case we'll use PostgreSQL
** '''JDBC URL:''' jdbc:postgresql://localhost:5432/openbravo where 5432 is the port where PostgresSQL is running and openbravo is the SSID of our database
** '''Username:''' tad (you can check your username/password in [[Openbravo.properties]] configuration file)
** '''Password:''' tad
* Click Finish button to generate the JDBC Connection
* Test your connection
* Save
[[Image:DataAdapterWizard.png|400px|thumb|center]]

Now we have to configure the query: we are going to list the products present in the database.
* Right-click on the Report Outline menu, and select '''Dataset and Query'''. Here is where we have to set the query of the report and it is also possible to switch between the available database connections in case we want to test the query.
[[Image:DatasetAndQuery.png|300px|thumb|center]]
* The products are stored in the M_Product table <source lang="sql">SELECT m_product_id, value, name FROM m_product</source>
* We have to add the fields based on your query which we want to use in the report, so we are going to add:
** m_product_id
** value
** name

[[Image:DatasetAndQueryDialog.png|300px|thumb|center]]
* Click OK

* Remember to clear the Scriptlet class and modify the Language for expressions
* Right-click on the Report Outline menu, and select '''Show Properties'''.
* In the report properties in the right, look for the following:
** Clear the Scriptlet class
** Choose Java as Language
* Save your changes
[[Image:ReportProperties.png|300px|thumb|center]]

Let's now design the Report Layout
* Put a static text as report title: ''Product List''
* Place the fields in the '''Detail''' band and a title in the '''Column Header''' band
* Save your changes
[[Image:ReportLayout.png|400px|thumb|center]]

* Switch to the '''Preview''' subtab to get a report preview
[[Image:ReportPreview.png|400px|thumb|center]]

{{(!)|Note: It is recommended to use Dejavu fonts in jasper reports because this fonts support most of the characters in almost all languages. Besides, Dejavu typography is the family of fonts that Openbravo included in jasperreports-fonts library.}}

=== Openbravo Runtime Environment ===
The standard reports in Openbravo (''src/org/openbravo/erpReports'') make use of several methods that reside inside the '''Openbravo Runtime Environment''', which cannot be executed at design time. For this reason, we provide the following '''[http://wiki.openbravo.com/w/images/4/47/Utility.jar .jar file]''' that encapsulates the following adapted methods of the ''org.openbravo.erpCommon.utility.Utility'' Class:

* '''public static BufferedImage showImageLogo''': returns a logo image that is already included in the JAR archive
* '''public static String applyCountryDateFormat''': always returns the date formatted in this pattern dd-MM-yyyy
* '''public static DecimalFormat getCountryNumberFormat''': just returns the same DecimalFormat received as parameter

For this, to be able to preview the standard Openbravo reports from '''JasperStudio''', it suffices just to import the .jar file into the classpath of the project within JasperStudio.

=== Adding images and logos to a report using the ShowImage API ===

You can use the Image BLOB reference to display an image for a specific report, or one of the Company logos in the application. First you need to add an image object to your report, set the expression class to "java.awt.Image" and the expression image to a call to the ShowImage function of the Utility class (if you want it to display a standard ImageBLOB image reference, that corresponds to a field added to a tab), or to the ShowImageLogo function if you want to display the logo of an Organization or Client.

Images loaded with this method must not have alpha channel. A transparency layer is not supported by the function that loads images in Jasper Reports.

* If you want to use the ShowImage function, you need to make the expression image look like:
** org.openbravo.erpCommon.utility.Utility.showImage("IMAGEID")
IMAGEID needs to be the UUID of the image you want to show. You could set this value using a Jasper parameter.

* If you want to use the ShowImageLogo function to show one of the logos, you have several options.
** This one will show the Company logo at System level:
*** org.openbravo.erpCommon.utility.Utility.showImageLogo("yourcompanylogin")
** This one will show the Company log at Client level (the client used will be the one the user logged at):
*** org.openbravo.erpCommon.utility.Utility.showImageLogo("yourcompanymenu")
** This one will show the Company logo at Organization level:
*** org.openbravo.erpCommon.utility.Utility.showImageLogo("yourcompanydoc", "ORGANIZATIONID")
ORGANIZATIONID needs to be the UUID of the Organization whose log you want to show. You could set this value using a Jasper argument. An example could be '''org.openbravo.erpCommon.utility.Utility.showImageLogo("yourcompanydoc", "4387D62C6486481AB3D148442A6AD34E")''' being 4387D62C6486481AB3D148442A6AD34E the organization ID.

== Registering the Report in Application Dictionary ==

=== Creating the Report ===
{{(!)| This feature is available from '''3.0PR15Q2'''}}

From '''3.0PR15Q2''' it is possible to create a report using a process definition. For more information see [http://wiki.openbravo.com/wiki/How_to_create_a_Report_using_Process_Definition here].

* Using the System Administrator role
* Using the quick-launch, open: '''Process Definition''' window
** You can find it in the menu: Application Dictionary > Process Definition

* Create a new record
* Fill all required fields
** '''Module:''' Pick your module
** '''Search Key:''' OBPF_ProductList (Is a best practice to start with your module's [[Modularity_Concepts#DB_Prefix|DB_Prefix]])
** '''Name:''' Product List
** '''UI Pattern:''' Report (Using JR templates)
** '''Data Access Level:''' Client/Organization
** '''Handler''': use the default org.openbravo.client.application.report.BaseReportActionHandler

[[Image:ReportProcessDefinition.png|600px|thumb|center]]

We must copy the .jrxml template file generated with Jaspersoft Studio into our module. When using Process Definition to generate a Report, templates need to be stored in the web folder of the module. In our example we place it in the following location: /web/org.openbravo.platform.features/jasper
* Navigate to the '''Report Definition''' tab
* Fill the PDF template field with the location of the .jrxml file

[[Image:ReportDefinitionTab.png|600px|thumb|center]]

=== Creating the Menu record ===
* Using the System Administrator role
* Open the Menu window
* Create a new record
* Fill all required fields:
** '''Module:''' Your module
** '''Name:''' Name of the menu entry (Product List)
** '''Description:''' Description of the action related to the menu entry
** '''Action:''' Pick Process Definition
** '''Process Definition:''' Pick your Process Definition (Product List)

[[Image:MenuProcessDefinitionReport.png|600px|thumb|center]]

== Compiling ==

After you have registered the report and menu entry in the Application Dictionary, you need to compile to generated the the necessary code.
<source lang="bash">ant smartbuild</source>

Once the compilation has completed, refresh your [[How_to_setup_Eclipse_IDE|Eclipse project]], and restart your tomcat server.

== Testing the Report ==
If you have completed all the steps, you should be able to open your Product List report form the quick-lauch, or menu entry.

[[Image:ProductList.png|600px|thumb|center]]

== Further Details ==
=== Layout ===
For information on how JasperReports handles the layout check [http://community.jaspersoft.com/wiki/making-html-xls-or-csv-friendly-reports Making HTML, XLS or CSV friendly reports]

Also, a tutorial with the basics of how to design a report can be found [http://community.jaspersoft.com/wiki/designing-report-jaspersoft-studio here].

=== Configuring Cell Type in XLS Reports ===

Starting from '''3.0PR15Q3''', by default, Openbravo reporting engine exports the XLS data as strings. This is done in order ensure that the exported data can be read after opening the report with the vast majority of spreadsheet applications.

If we want to have a particular format in a cell of our XLS report, and for example, display numbers inside a numeric cell, this default configuration can be overridden at template level.

To override this configuration, the following must be done inside the .jrxml report template:

# Add the '''net.sf.jasperreports.export.xls.detect.cell.type''' property with true as its value.
# Add a '''pattern''' for the text field that will be displayed in the XLS cell. With '''<pattern>''' tag a fixed pattern can be set and with the '''<patternExpression>''' tag it is possible to define a dynamic pattern.

Please note that the decimal and thousands '''separators''' used for the numeric cells exported in this way, will be those defined inside the spreadsheet program itself (LibreOffice Calc, Excel,...). An example of report which applies this configuration can be found [https://code.openbravo.com/erp/devel/pi/file/7c6686c84928/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml here].

=== Creating a Report Using Report and Process ===
'''Report and Process''' window was the habitual way to define reports before PR15Q2, as the '''Process Definition''' option was not available. In the following [http://wiki.openbravo.com/wiki/How_to_create_a_Report_with_iReport#Registering_the_Report_in_Application_Dictionary tutorial] you can find an example about how to create a Report in this way.

=== Creating a Reports in old releases ===
Before '''3.0PR15Q3''' version, another report design client was used, called '''iReport'''.

To get more information about this and further details on reporting in old releases, you can go [http://wiki.openbravo.com/wiki/Reports_obsolete here].

=== Report Compilation ===
{{AvailableFrom|3.0PR18Q3}}

When printing a report in the application, it is previously compiled at runtime. The result of this report compilation is cached if there are no modules in ''in development'' status.

Besides, it is possible to handle the state of this cache through a [http://wiki.openbravo.com/wiki/Retail:Monitoring_and_Management JMX] extension. Thus, this extension allows to:

* See if the cache is enabled.
* Enable/Disable the cache.
* See the list of reports whose compilation is stored in cache.
* Clear the cache contents.

[[Category:HowTo]]

How to create a Report - Revision history

Wikiadmin: Created page with "== Objetive == The goal of this how to is to describe the steps required to create a new report in Openbravo 3. The example explained is a simple report with a list of product..."