http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7638 Bug #: 7638 Summary: one page notice for printing per student? Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 - low Component: Notices AssignedTo: henridamien@koha-fr.org ReportedBy: melia@bywatersolutions.com QAContact: koha.sekjal@gmail.com Our schools want a paper notice to send to students. They want it to print one 8 1/2 x 11 page per student. They want all fines, fees, and lost to be on one report. I did create a SQL report that is working, but the schools want to be able to print this out on one piece of paper per student. Below is the SQL statement I made: SELECT b.cardnumber, b.surname, b.firstname, g.attribute AS 'Grade', h.attribute AS 'Homeroom', a.date, a.description, a.accounttype, a.amount, a.amountoutstanding FROM borrowers b JOIN borrower_attributes g on (b.borrowernumber=g.borrowernumber) JOIN borrower_attributes as h ON (h.borrowernumber=b.borrowernumber) JOIN accountlines a ON (b.borrowernumber=a.borrowernumber) WHERE b.branchcode =<<Pick your library|branches>> AND a.date between <<Date Between (yyyy-mm-dd)>> and <<and (yyyy-mm-dd)>> AND g.code='GRADE' AND h.code='Homeroom' ORDER BY a.accounttype ASC Name (Last, First) or in 2 separate fields Student ID number Grade Homeroom (even if the homeroom field is blank) Item Title Date Checked Out Due Date Item Status Amount Due -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.