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

0

Current Output:

User,msg no,comments
abc,101,xyz
abc,102,xxx
bac,105,xlx

Expected Output :

User,msg no,comments
abc,101,xyz
abc,102,xxx
abc=2
bac,105,xlx
bac=1

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

mailtosuganb's picture
Joined: Mar 21 2017 - 12:30am
Last seen: 2 years 7 months ago

2 Answers:

0

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. 

sadakar's picture
627
Joined: Aug 14 2012 - 3:57am
Last seen: 1 week 1 day ago
0

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

mailtosuganb's picture
Joined: Mar 21 2017 - 12:30am
Last seen: 2 years 7 months ago
Feedback