Creating Charts in Openbravo Reports

Reporting is a decisive factor that determines the reach of an ERP among the Users. OpenbravoERP in particular have laid a lot of emphasis on the reporting structures. iReport is the tool officially supported by Openbravo for generating reports within Openbravo.

iReport is an opensource java based reporting tool. iReport provides lots of features like sub-reports,crosstab references, and various presentation gadgets like charts, bar graph, plotted line, etc. I have provided the steps for creating charts in reports in Openbravo.For basic on developing reports in iReport, refer here. You can download iReport here.

Lets see an example. I have 10 product categories and 500 products. I want to see which products fall under which category and how much is the stock available. Lets see how this could look.

 If you have not worked in iReports before, you can take a look at this. You can download iReport here. To add a chart to a window, use the chart tool icon in the interface. A screen shot of where it is located is provided below:

Once you have added the chart, you can access the chart properties as provided in the below screen shot.

In the chart properties, go to chart data -> details. Here you can add the categories based upon which you want the data. Here I have added the category as product Category and the series values in terms of the products in that particular category. Here the following key points to be noted are:

1. Series Expression:

This represents the bars that appears on the chart. Here we want all the products with the count. so we choose the products here

2. Category Expression:

This represents the  x-axis. Here the product category is our base and we provide that here.

3. Value Expression:

Value is nothing but the quantity that determines the height of the bars in the report. Here we are providing the count of each product.

4. Label Expression (optional) :

This provides the additional information about the bars in the chart that is provided under the chart. If its left empty, the name from the value expression will be pulled up.

Once all this is done, refer to the steps to import the same in the Openbravo Application and if you run the report, you will get the following output.

Having presented all this, generating reports in this format is really helpful. However Openbravo has now become the agile, tamed ERP…:). There is a new and powerful feature widgets.

About Pandeeswari Ramakrishnan
Applications Engineer, Openbravo

3 Responses to Creating Charts in Openbravo Reports

  1. The post was indeed good. But it would be great if another post related to basic report creating tasks like, Typecasting data, Parameters, Sub-reports are also presented. I have faced lots of issues regarding that and it took lots of time to resolve it.


  2. Pingback: Reference Types in Openbravo « Fugo Consulting

  3. Pingback: Sub-Reports in Openbravo « Fugo Consulting

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: