Lets share love

How ? copy url of this blog and share in your social network :) simple

12

Tuesday, December 31, 2013

Charts in iReport

Creating charts that is pie-chart , bar diagrams is very easy. you can create fascinating charts in minutes with iReport. With following steps you can create awesome looking and accurate charts with iReport. Here is am going to discuss about creating a pie-chart. 1. Create a new report. 2. Remove all bands except detail and summary band . we will put pie-chart in summary band. 3. Now write a query to get your data from database. In my case :  ...

Count(*) and Count(column_name) in SQL

Count (*) returns numbers of rows with in the table  And  Count (Column_name) returns numbers of rows which contain the that particular column .&nbs...

Monday, December 30, 2013

sum of columns in iReport , jasper reports

okay today i am working on jasper reports and tool to design jrxml file iReport. So on this post i will help you to sum up all the integers of the columns. first of all you have to fetch data from datasource by writing query. now yo have a column that you want to sum . now yo need to create a variable . for that right click on variable. as in following image. name the variable as SUM . now set following poperties to the SUM.  now...