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@liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ 2009/7/23 ils rehoboth <rehoboth_ils@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha