https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13914 --- Comment #10 from Sophie MEYNIEUX <sophie.meynieux@biblibre.com> --- This patch fixes how the SQL request is built. Union must be done before aggregation and not after, you have 2 results for each value and not the sum of it. Test plan ========= On Reports > reservations, select all statuses as line, pickup library as column (empty) and a range of hold date. Keep the results Run the same reports but with statuses as column and pickup library as line You should get the same results on another display. * Without patch, if you've got representative data, most of the time you can observe significant differences between both results * With the patch, results are always the same (and right if you request directly your database) -- You are receiving this mail because: You are watching all bug changes.