Bug 14531

Summary: Check-in statistical report broken
Product: Koha Reporter: Tomás Cohen Arazi <tomascohen>
Component: ReportsAssignee: Galen Charlton <gmcharlt>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
See Also: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14598
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: Correct (checkouts)
Wrong (checkins)

Description Tomás Cohen Arazi 2015-07-14 14:22:15 UTC
The check-ins statistical report shows wrong data (at least) if you choose itemtype -> column and grouping by month.

Steps to reproduce:
- Go to Reports > Circulation statistics
- Choose a period (row) when there is circulation
- Choose to group 'Checkout' by month
- Run report
=> SUCCESS: you see checkouts numbers by month and by item type
- Go back and choose to group 'Checkin' by month
- Run report
=> FAILURE: you see all cells contain zeros (and they shouldn't) and there is a weird NULL column, with the sum of the checkins (same value as 'Total' column).
Comment 1 Tomás Cohen Arazi 2015-07-14 14:23:01 UTC
I tested this and it goes back (at least) up to 3.12.x
Comment 2 Tomás Cohen Arazi 2015-07-14 14:25:50 UTC
Created attachment 40991 [details]
Correct (checkouts)
Comment 3 Tomás Cohen Arazi 2015-07-14 14:26:09 UTC
Created attachment 40992 [details]
Wrong (checkins)
Comment 4 Tomás Cohen Arazi 2015-07-14 14:31:24 UTC
I forgot to add a step: choose to group by itemtypes in columns.
Comment 5 Tomás Cohen Arazi 2015-08-05 18:30:44 UTC

*** This bug has been marked as a duplicate of bug 14598 ***