Archiving Borrowers

Find records with no holdings with Reservations

Procedure to identify bibliographic recoreds with no holdings that also have active reservations.

Heavy Reserved items

Long_Overdue_selects_with_barcodes Produces a list of very long overdues,with accn numners in numeric and barcode font.  A work around for bulk processing items through circ maintennace.  I found the barcodes scan best if printed straight from crytsal Reports rather than saved to an excel file etc. 

Ser_subs_complete A list of serial subscriptions sorted by branch and then by collection.  User can select start and end date of subscription to include in report

Serials_issues_by_branch_and_date Before opening this report, set datasource location and change selection parameters for your library.

Issues_by_branch_by_collection_for_fin_year_-_not_renewals

Issues for financial year by branch by collection. Not including renewals - just remove that part of the select statement to count all issues.

To change the breakdown to just by collection or just by branch, delete one of those cells from the table and it will recalculate the table without that sort criteria.

A very simples report - what could possibly go wrong?