how to sum an entire column?

Hi, I started working with jaspersoft studio recently and faced such a problem. At the end of the report, I need to calculate the sum of the columns, but if I use the "textfield wizard", then it counts only the last page when I need to calculate a row from all pages. If you create a TextField and add it via Numeric sum, then it generally displays the last line. How do I make a column from all the pages sum up?

Attachments: 
deadsploid's picture
Joined: Nov 9 2022 - 1:06am
Last seen: 2 weeks 19 hours ago

1 Answer:

Hi, 

you can use the Summary Band after your Details and Groups.

Add the Band to your Outline and drag the Field to that area and select "sum" for the calculation.

It should look like this:

And the result should be displayd on the last page below your Details Band:

Hope that helps. 

Regards TT

 

 

 

 

 

ttibcken's picture
692
Joined: Nov 23 2021 - 2:51am
Last seen: 9 hours 42 min ago
Feedback
randomness