Jump to content
Changes to the Jaspersoft community edition download ×

how to sum an entire column?


deadsploid
Go to solution Solved by Thomas Tibcken,

Recommended Posts

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?

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

  • Solution

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.

bildschirmfoto_2023-04-19_um_09_15_59.thumb.png.fdb6942a9ecc4238cd22675bf5429163.png

It should look like this:

bildschirmfoto_2023-04-19_um_09_15_26.png.e479ad005e66c185f575a762e222c3b0.png

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

bildschirmfoto_2023-04-19_um_09_15_12.png.f43d38bb0d41012bfc8282e3bca8d9c7.png

Hope that helps. 

Regards TT

 

 

 

 

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...