romaldus 7/7/2017 | |
Hi at all, I am using running totals in a car logbook solution and followed the tips given here. Works nicely. Problem is, that the running totals for the total mileage only show the correct result, if all records are shown in the correct order. If you change the order or want to print lets say only May from a year´s logbook, you get nonsense values. Is there a way to print partial reports with correct running totals without saving the totals to a field in the database? That is not only taking space, but problematic too, if records can be deleted or corrected.
|
mbintex author 7/8/2017 | |
here you are.
|
romaldus 7/8/2017 | |
Have you tried using filter panel? (filter by month) |
mbintex author 7/8/2017 | |
That is not the problem - surely you can easily filter, select and search for records. |
romaldus 7/8/2017 | |
That is not the problem - surely you can easily filter, select and search for records. But then the running total is newly calculated based on the resulting records and gets completely wrong.
|
mbintex author 7/9/2017 | |
Thanks Ronaldus, if ($data["Fahrenbuch"]==$_SESSION["Fahrenbuch"])
|
admin 7/11/2017 | |
The only reliable way to implement multi=page running total is to use the approach suggested in this article (MySQL only): |
mbintex author 7/12/2017 | |
Yes, I already had this in MySQL Workbench: set @summe:=0;
|