Table of Contents

Sample Report Templates and SQL Queries

This page is a work in progress

Report Template Posting Guidelines

When posting a report template to these pages, please include:

  1. A descriptive title for the template.
  2. A brief description of what the template does and how it can be used
  3. Attribution so that you or your organization can be contacted with questions about the template
  4. A screenshot of filters and display fields. Take your screenshot BEFORE changing the label if possible, and/or include "Column" in the grid

Report Template Categories

BIB RECORD REPORTS (WIP)

ITEM REPORTS (WIP)

BORROWER REPORTS (WIP)

CIRCULATION REPORTS (WIP)

STAFF REPORTS (WIP)

BILLINGS REPORTS (WIP)

HOLDS REPORTS (WIP)

REPORTS ABOUT REPORTS

ACQUISITIONS REPORTS Courtesy of the Acquistions Interest Group

Old Sample Report Templates

Templates below are meant for use with older versions of Evergreen (2.0 and earlier). Use with caution!

OLD SAMPLE REPORT TEMPLATES

SQL Report Categories

ITEM REPORTS

BORROWER REPORTS

CIRCULATION REPORTS

STAFF REPORTS

AUDITOR TABLES