Report Builder Total Error

[LifeP]

I created a Pending Invoice summary using report builder.
This is used to send summary of invoices for reconciliation at the end of a period.
However it shows a random extra line row 12 without any invoice number
Also the “show total” row 13 is messed up.

I created another report from scratch. Turns out the row 12 is total. (which is wrong anyway)
Observation : row 13 is twice of row 12
There seems to be some error in show total logic.

Row 12 showing even when add total row is unticked

[Zlash65]

Seems like an issue when viewing long list of data. Show_total creates a row upto that length of list, and if we click on more i.e to get the whole list, another row is added at the end of the list while the previously partial list total still remains and the final total includes the summation of lists data + partail total.

Also, I think 'show total' and 'show all data' starts functioning as some sort of toggle, if the 'show total' is not clicked and 'show more data' is clicked, still the total is displayed

[Zlash65]

frappe/frappe#4186