Running total or cummulative sum in Jasper reports

[peter.johnson]

Is there a way in a report to have a running total for a column? This seems like a fairly standard feature for reports, but I can't see any way to do it.

 

[hozawa]

Just create a variable and set Calculation to "Sum", Expression to the field that you want to sum, Initial Value Expression to "0", and Reset type to "Column".

If you create a group, you'll be able to set the Reset type to the group that you created.

FYR:

https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v71/defining-or-editing-variable-0

[peter.johnson]

I've seen that suggested before, but I am not seeing any way to create a variable from within an Ad Hoc view. The link attached was for Jaspersoft Studio, which is not what I am using. I am working with a version of Jasper Reports Server that is embedded within another application, Medidata Edge CTMS.

[Friendly User]

For ad hoc, unfortunately, there is no way to create a running total right now. You can create group totals, row totals, column totals or total totals but not running totals. This is something planned to be added in future.