Re: [Koha] Overdue report/count at year-end

I decided to go ahead and try to implement prompting for the year inside of the Koha report and here's the SQL I came up with (enter the year twice when prompted): SELECT month(returndate) AS `MONTH`, COUNT(*) AS `OVERDUES` FROM old_issues WHERE returndate > date_due AND returndate > concat(<>,'-0

Re: [Koha] Overdue report/count at year-end

Message- From: Katrin Fischer [mailto:katrin.fischer...@web.de] Sent: Saturday, August 02, 2014 8:13 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Overdue report/count at year-end Hi Steve, I think I'd start with comparing the date_due and the returndate in old_issues to figure out

Re: [Koha] Overdue report/count at year-end

Hi Steve, I think I'd start with comparing the date_due and the returndate in old_issues to figure out which items were returned late and go from there. Hope this helps, Katrin Am 01.08.2014 um 18:02 schrieb Steven Nickerson: > Hello everyone, > > We have implemented one of the overdue rep

[Koha] Overdue report/count at year-end

Hello everyone, We have implemented one of the overdue reports from the Report Library and that gives us a snapshot of the overdue count at the point in time when the report is run, but is there any way to get a count (by month, for example) of the number of items that were overdue throughout