Skip to main content

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.For basic on developing reports in iReport, refer here. You can download iReport here.

                   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.

Comments

Popular posts from this blog

My 10 years in Application Development

It's been around 10 years since I started programming. May be a bit more, if I have to include my first attempts at C programming in school. But it would be a grave insult to call remembering ten lines of code and just replicating it to put a star on the screen. I also did a course on Visual basic, but it was more gimmicks that Application development. But it was truly in the year 2007 when I started my Master in Computer Applications that I found a new flare for developing applications. 
I was very late to computers in general and even when I joined my Masters, computers were not really accessible to me. But when I joined my Masters where one is actually expected to hone the skills which they already have, but in case it was were I was learning the skills, initially it was very difficult. I was not sure what computers had for me nor I had a natural flair for programming. But the thing about computers that attracted me was the visual medium it gave. Initially it was just a door t…

Changing Timezone in Postgresql, Ubuntu

Timezone and locale are integral concepts that one should be aware of when implementing a System. For example. if you create a database in PostgreSql, it will use the default System settings for the database. Lets say you have a server in UK and your client is US. If the client tries to retrieve the current date or time, it is going to show the UK time and not the US one.
Today I encountered a different issue in our client place where the Ubuntu timezone and PostgreSql timezone were showing a incorrect values. Instead of Indian Standard Time (IST) it was showing Pacific Daylight Time(PDT). These are the steps that I followed to change the timezone to IST in PostgreSql and Ubuntu.
Changing timezone in Ubuntu:
sudo dpkg-reconfigure tzdataYou will be prompted to choose the continent and then the area. Provided screen shots where we configure the location.
Use TAB key to navigate to the OK button and then press Enter.

The changes will get reflected immediately. To check it you can open a n…

Apps to install after installing Ubuntu

Here are the list of apps that I almost use on a day to day basis. This blog will be updated with the apps in the subsequent versions.

Docky (MAC like doc)Nylas N1 (Email client)SkypeVimPathogen package managerTwitvimNERDTreeSublime TextVLC Media PlayerSSHUnity tweak toolOpenbravo ERP stackJavaAntPostgresqlTomcatEclipse IndigoNode.js (useful for many plugins)Google ChromeNoobs Labs Ubuntu themes and iconsTeamviewerFogger App