I am using the SQL report below for generating Total Fine Paid: SELECT accountlines.Date,borrowers.Cardnumber,borrowers.surname AS > "Students Name", borrowers.firstname AS "First Name", accountlines.Amount > As "Paid Amount" > FROM accountlines, borrowers > WHERE borrowers.borrowernumber = accountlines.borrowernumber AND > accounttype = 'pay' AND date BETWEEN <<Between Date (YYYY-DD-MM)|date>> > AND <<and (yyyy-dd-mm)|date>> > AND borrowers.branchcode=<<branchcode|branches>> > ORDER BY accountlines.Date
Is it possible to add the shelving location? We use the shelving location as library sections and we want to determine the paid fines per library section. Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha