How to get row count of the database field using iReport

Go through from  step 1 to step 3 of the above section(1. How to get summation of the database field)
Then go to the XML viewer and edit variable tag and add the variable Expression tag in the jrxml file

           

In the variable tag

·         Name is the added variable’s name.

·         Class is the data type of the calculated field.

·         Calculation is summation of the given field.

                                In the Variable Expression tag

·         Display the field which want count

 

      Then save the report and compile. After that go to the Preview mode and see the out put.in the last page display the row count of the amount field. If compare with the data base both display the same value for the count of the amount field.