iReport Pie Chart Report

This blog i will show how to make a pie chart report. here i used very simple report. I have one table called category it has different categoryno with categroy name. Each category has subcategory. I want to show how many categories are there by pie chart.  Category table struc and data link will give you the table structure and some sample data. I used MySql database for this report.

• Create New document from iReport. use this band value title = 30, columnHeader = 15, detail = 15 and summary = 300 and others = 0.
• Add Query:     select category “Cat No”, subcat_name “category Name”, count(category) total from category
  group by category order by 1
• Add 3 fields – Cat No, Category Name, Total to Detail band.    
• Click the char button and select the Pie 3D. I put its width is 268 and height is 203.  
• right click on chart and select cart properties. select cart data tab, select the Details tab. and put the value as follows -  for Key Expression = $F{category Name} ,  Value Expression = $F{total},  Label Expression = $F{category Name}
• click close.
• b4 execute you must select your database connection. now click Execute with data connection. the output file will looks like as follows

Advertisement