Library Circulation Report

Current Checkouts - Sorted by Due Date

Report Group

Circulation Management

Report Subgroup

Checkouts Tracking

Report Name

Active Loans Report

i What This Report Covers

• All currently checked out items sorted by due date (earliest first)
• Borrower contact information (name, phone, email)
• Complete item details (title, author, call number, barcode, location)
• Essential for circulation management and overdue tracking

SQL Query

SELECT c.date_due, p.surname, p.firstname,
       p.phone, p.email, b.title, b.author,
       i.itemcallnumber, i.barcode, i.location 
FROM issues c
LEFT JOIN items i ON (c.itemnumber=i.itemnumber) 
LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber) 
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) 
ORDER BY c.date_due ASC

⇣ Report Columns (In Output Order)

1

date_due

Due date for the checked out item

2

surname

Borrower's last name

3

firstname

Borrower's first name

4

phone

Borrower's contact number

5

email

Borrower's email address

6

title

Title of the checked out item

7

author

Author of the item

8

itemcallnumber

Call number for locating the item

9

barcode

Unique item identifier

10

location

Physical location in library

Columns appear in this exact order in the report output, sorted by due date (earliest first).

Usage Notes

This report helps circulation staff track all checked-out items and their due dates. Use it to:

• Generate overdue notices
• Contact patrons about upcoming due dates
• Monitor circulation patterns
• Reconcile inventory records

Custom Reporting Services

We offer powerful and fully customized reports that help libraries clearly understand and manage their collections and daily operations. Whether you want to track book issues, review your entire collection, manage inventory, or analyze useful statistics, we can create reports that perfectly match your library's unique needs. These custom reports help you save time, work efficiently, and make smart, data-based decisions for your library.

Get Custom Reports