[Koha] SQL for a report of overdue accounts.

[Tony Morton]

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 at waimatedc.govt.nz |   www.waimatedc.govt.nz



______________________________________________________________________________
This email has been scrubbed for your protection by SMX.
For more information visit http://smxemail.com
______________________________________________________________________________