Dear All, Anybody has worked on patron's complete report on Issue, return, renewal, for an accession no between two date ranges?
The Requested output format is: SERIAL NO | BORROWER'S CARD NO.| BORROWER'S NAME | PATRON CATEGORY | ITEM TYPE | ACCESSION NUMBER (BARCODE) | ISSUE DATE | DUE DATE | RENEWAL DATE| RETURN DATE| TITLE | AUTHOR | PRICE This report is requested by head of my institution. I can only generate either checkout or checkin reports from the SQL Wiki page. I am also using following url: http://schema.koha-community.org/tables/issues.html for writing sql, but not succeeded. Therefore, I request here to share the sql, if you had already generated or worked on similar kind of report/s or any kind of directions would be helpful. With thanks. Satish MV Librarian Govt. Engineering College, Hassan. Karnataka 573 201 _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
