I am a newbie want to count the column and print the sum of columns below it in iReport[jrxml]

[mailtosuganb]

Current Output:

User,msg no,commentsabc,101,xyzabc,102,xxxbac,105,xlx[/code]

Expected Output :

User,msg no,commentsabc,101,xyzabc,102,xxxabc=2bac,105,xlxbac=1[/code]

Please help me to count the number of columns and display the sum as mentioned in the expected output

 

[sadakar]

Create group by band with User . 

Group by band will have header and footer section. 

In group footer, drag teh "user" field and drage "user" or "msg" field. When dragging "msg" field the studio engine auto create a variable and ask you for the type of calculation. In your case take count. 

It should solve your problem. 

[mailtosuganb]

Thanks sadakar, but after dragging the fields the studio engine auto create a variable but didn't ask me for the type of calculation [Jaspersoft ireport designer professional 5.2.0]. Kindly, please advice