Hi Tony, it should be possible to get you a report with borrower information and the total of the charges. What I am not sure about how to do it is the description of all charges grouped by the date of the first charge. I am not sure I understand well what you want to do here. We haven't done a report like this for our libraries yet, because most of the time overdue notices get sent out by email and there are only very few patrons without email addresses. We are using the overdue notice triggers in Koha. The overdue_notices job has an csv and I think also an html option, maybe one of those could work for your purpose? Hope that helps, Katrin -----Ursprüngliche Nachricht----- Von: koha-bounces@lists.katipo.co.nz im Auftrag von Tony Morton Gesendet: Di 30.10.2012 04:20 An: schnydszch; koha@lists.katipo.co.nz Betreff: [Koha] SQL for a report of overdue accounts. Hello Fellow Koha users, Firstly let me say I have tried the standard reports and building my own report but I can't get it to do what I want. I need to be able to produce a report that has the Borrowers contact details, a description of all charges, total of all charges but is grouped by the date of the first charge. With this information I can mail merge to send out letters for overdue accounts. If you do this in a different fashion I would be interested to know (I'm willing to change). Thank you Tony Morton | Senior Librarian Waimate District Library Waimate District Council | 125 Queen Street | PO Box 122 | Waimate 7960 | New Zealand |: +64 3 689 0000 | DDI: +64 3 689 0071 | ?: +64 3 689 8075 | Mobile: +64 0210740867 0: tony@waimatedc.govt.nz | ? www.waimatedc.govt.nz ______________________________________________________________________________ This email has been scrubbed for your protection by SMX. For more information visit http://smxemail.com ______________________________________________________________________________ _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha