Jun 10, 2011
by Shankar Balachandran
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.
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.
There are three presentation output types provided by Openbravo. You can use that by defining a parameter called output type. This will help us to view the report as Html, Excel, PDF. Note that when you are using charts or any images like these, it will come properly only in PDF or Excel view. The html view may not present the image.
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 called widgets. You can gather more information about it here.