I found Nicole's report in the SQL library for "Patrons with fines".
I modified it to allow our libraries to choose their "branch".
But it doesn't seem to run.
Can someone show me where the problem is, please?
Kathy -----------------------------------
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 AND borrowers.branchcode='__BRANCHCODE__' GROUP BY borrowers.cardnumber ORDER BY borrowers.surname ASC Kathleen D. Rippel Dept. Head/Consultant--Resource Sharing and Access ; Pathfinder Central (Manager) Central Kansas Library System 1409 Williams Great Bend, KS 67530
(620-792-4865) phone (800-362-2642) toll-free, KS (620-792-5495) fax
kdr@ckls.org ******************************************************************************************** I'm currently reading: This fatal writ, by Sara Woods. I'm currently listening to: The passage, by Justin Cronin.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
In 3.2 the parameters are defined like this: <<Select your branch|branches>> So instead of: '__BRANCHCODE__' Use the <<Select your branch|branches>> and it should work. :) The complete how-to is in the manual: http://koha-community.org/documentation/3-2-manual/?ch=x15127#runtimefaq Liz Rea NEKLS 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 AND borrowers.branchcode=<<Select your branch|branches>> GROUP BY borrowers.cardnumber ORDER BY borrowers.surname ASC