[Koha] Overdue reports

[Nicole Engard]

I have contributed this very type of report to the SQL Reports page:
http://wiki.koha.org/doku.php?id=sql_library


SELECT  borrowers.cardnumber, borrowers.surname, borrowers.firstname,
        FORMAT(SUM(accountlines.amountoutstanding),2) as due
FROM borrowers LEFT JOIN accountlines ON
(borrowers.borrowernumber=accountlines.borrowernumber)
WHERE accountlines.amountoutstanding > 0
GROUP BY borrowers.cardnumber
ORDER BY borrowers.surname ASC



---

Nicole C. Engard
Open Source Evangelist, LibLime
(888) Koha ILS (564-2457) ext. 714
nce at liblime.com
AIM/Y!/Skype: nengard

http://liblime.com
http://blogs.liblime.com/open-sesame/



2009/7/23 ils rehoboth <rehoboth_ils at yahoo.com>:
> Hi all,
> I am using  koha-3.00 and i am trying to generate list of patrons who have
> overdue fines but i am not finding how to do it. Can something please help
> me.
> Thanks in advance
> Rehoboth
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>