====== 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:

  - A descriptive title for the template.
  - A brief description of what the template does and how it can be used
  - Attribution so that you or your organization can be contacted with questions about the template
  - 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 =====

**[[evergreen-reports:templates:record|BIB RECORD REPORTS]]** (WIP)

**[[evergreen-reports:templates:item|ITEM REPORTS]]** (WIP)

**[[evergreen-reports:templates:borrower|BORROWER REPORTS]]** (WIP)

**[[evergreen-reports:templates:circulation|CIRCULATION REPORTS]]** (WIP)

**[[evergreen-reports:templates:staff|STAFF REPORTS]]** (WIP)

**[[evergreen-reports:templates:billings|BILLINGS REPORTS]]** (WIP)

**[[evergreen-reports:templates:holds|HOLDS REPORTS]]** (WIP)

**[[evergreen-reports:templates:reports|REPORTS ABOUT REPORTS]]** 

**[[acq: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!//

**[[scratchpad:sample_reporter_templates|OLD SAMPLE REPORT TEMPLATES]]**

===== SQL Report Categories =====

**[[evergreen-reports:sql:item|ITEM REPORTS]]**

**[[evergreen-reports:sql:borrower|BORROWER REPORTS]]**

**[[evergreen-reports:sql:circulation|CIRCULATION REPORTS]]**

**[[evergreen-reports:sql:staff|STAFF REPORTS]]**

**[[evergreen-reports:sql:auditor|AUDITOR TABLES]]**