There is a report that does just that listed on this page:<br><br><a href="http://wiki.koha.org/doku.php?id=sql_library" target="_blank">http://wiki.koha.org/doku.php?id=sql_library</a><br><br>it's this one:<br><br><pre>
SELECT borrowers.cardnumber, borrowers.surname, borrowers.firstname, <br>
FORMAT(SUM(accountlines.amountoutstanding),2) as due <br>FROM borrowers LEFT JOIN accountlines ON (borrowers.borrowernumber=accountlines.borrowernumber) <br>WHERE accountlines.amountoutstanding > 0 <br>GROUP BY borrowers.cardnumber <br>
ORDER BY borrowers.surname ASC</pre><br><br><div class="gmail_quote">2009/8/10 Akin Adigun <span dir="ltr"><<a href="mailto:akinomatics@yahoo.com" target="_blank">akinomatics@yahoo.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;" valign="top">
Hello,<br>I am using koha 3.0.1 on suse 11.0 with nozebra configuration<br><br>Pls I need queries on modification log for patrons and queries on patron that have fine againt there record and having fine above the nochage amount<br>
<br>thanks<br><br><div>Akin Adigun <b><font color="#0000bf">(MCP)</font></b> <br>Akinomatics <br>Tel: +2348035565348, +2348029219271</div></td></tr></tbody></table><br>
<br>_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br>