I answered this on list last week for someone else - this is a possible custom report that will work: I have one that gives me all the patrons with fines and the amount of the fine: 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/ On Fri, Mar 27, 2009 at 12:06 AM, Harjeet Singh <harjeet.singh@chitkarauniversity.edu.in> wrote:
We are using Koha 3.0 version. we want to generate a report of fines. Please help me for this. -- View this message in context: http://www.nabble.com/Fine-report-is-not-generated.-tp22735801p22735801.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha