Chart Report

You can have may chart types as described in Introduction to Reports. In this section, the bar chart will be used to show how you can work with predefined chart types.

Add Report

You should add a data source in order to retrieve the data from your database table. We are going to create table from h2 database and data was created from the KPI Monitoring Sample sample. Since no data source was added to the h2 table which is used in the sample, step 1 to step 4 will explain steps to add a data source. If you have already added a data source follow steps from step-5.

1. Go to Configure -> Data source. And click on Add Data Source
   
   
2. Fill the the details about the data source which you are going to add. Since here we are using the KPI sample generated data source the following details are entered.
   
   Driver: org.h2.Driver
   URL: jdbc:h2:repository/database/samples/WSO2CARBON_DB;AUTO_SERVER=TRUE
   Username : wso2carbon
   Password: wso2carbon
   
   
3. Click on Test connection to validate the connection.
   
   
4. Click on add to add the data source to the WSO2 server.
   
   
5. Click on Tools -> Reports -> Add. and select Bar Chart Report.
   
   
6. Enter the chart details as shown below. You can select the preferred database and the table for which you are going to generate the report. Since here we are going to generate the report from newly added database, select 'phone_retail_store' as the data source. and select the table which you are going to use. According to your selection the fields will be updated. As you can see in this chart we are going to have two series in same chart. If you want to add more, you can click on the add series add more series to your chart. 
   And click on Next Button.
   
7. Enter the report formatting details as you prefer in the second step.
   
   
8. Click on create button.

9. This will take u to the list page of reports. 

Generate Report

1. Click on the report name in the list of reports (Tools -> Reports -> List)
   
   
2. This will take you to the generate page. Click on the proffered report format. Here pdf was selected.
   
   
   
   

Click on the generate button. and then there will be download pop-up to save the generated report, click on save and download your report. 

Generated report: