I have created a report with two groups using group-sums . The last group-sum before the pagebreak shows the wrong value.
All group-calculations (sum) are correct - except the last one. This happens when the report places the group-footer for the 1st group on the next page - in this case the group-calculation of the last group is wrong.
The group values for the yearweek group should be as follows:
But when the report produces a page-break placing only the groupFooter on the next page - the last group reads like this:
2022/05 85 <- displays the value from the prevous group.
Executing the attached report in the Tibco JaspersoftStudio 6.18 will show the described error every time - The Report-Data itself is provided within the select-statement (use an MYSQL-Datasource).
- Changing band-height will solve the this problem
- Changing number of data-rows will solve the this problem
But the problem underneath remains ... only the case to reproduce the prodlem will be different.
See the attached screenshot for bug-representation
I had this issue posted in forum before - no solutions yet: