# Reports

This section explains how to generate and send the daily notices that remind borrowers about overdue, almost-due, or lost items, and how to run the reports that tell you which items need to be put on hold, sent elsewhere, or re-shelved.  It also explains how to use the Item Report and Adhoc Stats features to help manage your collection.

## Circulation Reports

<table border="1" id="bkmrk-the-circulation-repo" style="border-collapse: collapse; width: 100%;"><tbody><tr><td style="width: 52.8866%; vertical-align: top; border-style: none;">The Circulation Reports window is opened by clicking on its button:</td><td style="width: 47.1134%; border-style: none;">![Circulation Reports button](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/F4M7YOTpMHl8vkeQ-Circulation-Reports-Button.PNG)</td></tr></tbody></table>

<p class="callout info">The window opens separate from the rest of Horizon, so you can still access circulation functions while reports are being generated and output.</p>

---

### Circulation Notices

[![Printer icon](https://documentation.nlpl.ca/uploads/images/gallery/2019-03-Mar/scaled-840-0/LCy4UQZZL8OJ9Isz-Printer-icon.png)  Printable Quick Guide: Circulation Notices](https://staff.nlpl.ca/horizon-guide/quick-guides/Circulation-Notices.pdf)

<iframe allowfullscreen="allowfullscreen" frameborder="0" height="315" src="//www.youtube.com/embed/UjeOJJYXZE8" width="560"></iframe>

<p class="callout warning">Circulation Notices must be run daily.</p>

Running notices is a 2-step process: they have to be **generated *and then* outputted**.  There are 2 batches to run, *Auto Notices* and *Pre-Overdue Notices*.

*Auto Notices* will send reminder emails to borrowers with overdue items, tell borrowers about items being held, and print letters for borrowers with lost items.

*Pre-Overdue Notices* will send reminder emails to borrowers 4 days before items are due back.

Emails about overdue and held items will only be sent to borrowers who have an email address record in their borrower record.

Pre-overdue reminder emails will only be sent to borrowers who also have the *PreOverdue* option selected in their record:

![Option for borrower to receive notices by email, selected in their borrower record](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/mSnc75iltUpJQfZJ-Select-Email-Notices.PNG)

You can check this by going into the borrower’s record from the checkout window:

- - - search for the borrower or scan their card
        - press **\[F6\]**

To begin generating the notices:

- - - open Circulation Reports
        - select from top menu **Notices &gt; Notice Output**

The Notice Batch List opens.  It lists all the notices that have been recently generated across the province.  The notices that you are about to generate will appear at the bottom of this list.

![List of Batch Notices sent from all locations](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/M7Y0r8TI1gysHf0N-Notice-Batch-List.PNG)

<table border="1" id="bkmrk-to-generate-the-auto" style="border-collapse: collapse; width: 100%;"><tbody><tr><td rowspan="5" style="width: 34.9485%; vertical-align: top; border-style: none;">To generate the Auto Notices:

- - click on **New Batch**

- - click on **Auto notice**

- - select your location in the list

- - click on **OK**

</td><td rowspan="5" style="width: 65.0515%; vertical-align: middle; border-style: none;">![Pop-up box that lets the user choose which type of notice to generate](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/QW7OxCE25H7VZUc5-Select-Notice-Type.PNG)</td></tr></tbody></table>

<p class="callout info">If there are no notices to generate then Horizon will tell you.  That often happens at smaller sites.</p>

Generate the Preoverdue Notices in a similar way:

<table border="1" id="bkmrk-click-on-new-batch-c" style="border-collapse: collapse; width: 100%;"><tbody><tr><td rowspan="5" style="width: 68.0412%; vertical-align: top; border-style: none;">

- - click on **New Batch**

- - click on **Preoverdue notice**

- - select your location in the list

- - click on **OK**

</td><td rowspan="5" style="width: 31.9588%; vertical-align: middle; border-style: none;"> </td></tr></tbody></table>

When both sets of notices have been generated scroll to the bottom of the list.  The quickest way is to press **\[Ctrl\] + \[End\]** on your keyboard.

Select the notices for your location, making sure that the last output date is blank:

![The Batch Notice window with 2 batches selected to be output](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/PRsTGLCeoSbf7NU4-Select-Batches-to-Output.PNG)

<p class="callout danger">If the date is not blank it means that someone else has already output the notices for your site.  **Don’t output them again.**</p>

<p class="callout warning">Click on **Output** to email and print the notices.  **If you don’t do this then messages will not be sent.**</p>

Emails will be automatically sent.  If any emails cannot be sent then an error message will appear, and you will need to submit a support ticket to IT.  See the section on [<span style="color: #000080;">*Troubleshooting*</span>](https://documentation.nlpl.ca/books/horizon-guide/page/troubleshooting).

If any letters have been printed for lost items, check the shelves for the items before mailing.

---

### If the Printer Jams and Notices are Lost

Notices can be reprinted:

- - - highlight the Auto Notices for today for your location 
            - if you are coming back later to do this make sure to choose the correct date
        - click on **Select**
        - a list of borrowers who should have received notices appears 
            - notices sent by email have a blue tick in the email column
        - highlight the notices to be reprinted
        - click on **Output** to print

![Pop-up window that lets the user to select which notices to (re-) output](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/tFBsWI3wyeWCF1wU-Notices-Selective-Output.PNG)

---

### Request Pull List

[![Printer-icon.png](https://documentation.nlpl.ca/uploads/images/gallery/2019-03-Mar/scaled-840-0/LCy4UQZZL8OJ9Isz-Printer-icon.png)  Printable Quick Guide: Requests and Holds](https://staff.nlpl.ca/horizon-guide/quick-guides/Requests-and-Holds.pdf)

<iframe allowfullscreen="allowfullscreen" frameborder="0" height="315" src="//www.youtube.com/embed/PngJDpvKN7U" width="560"></iframe>

The Pull List is the list of all items that need to be fetched from the shelves and put on hold for borrowers or sent to other locations.  Scan the items into the checkin and Horizon will tell you what to do.

<p class="callout warning">The pull list must be requested daily, and at smaller sites it may often be empty.</p>

To request the pull list:

- - - open Circulation Reports
        - select from top menu **Requests &gt; Request Pull List**
            - this message will appear:

![Pop-up message that lets the user know that the Pull List is being generated](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/JwxZC8yHB6Cd5uap-Pull-List-Message.PNG)

It can take some time before the list is generated, but while that’s happening you can go back into Horizon and use other circulation functions if need be.

You will need to print the list and go find the items on the shelves.  However when first generated it provides too much information about each item to print tidily:

![The Pull List, with results unsorted](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/HAKPkr63coekxI4V-Pull-List-Messy.PNG)

<table border="1" id="bkmrk-so-click-on-display-" style="border-collapse: collapse; width: 100%;"><tbody><tr><td rowspan="5" style="width: 42.2681%; vertical-align: top; border-style: none;">So click on **Display** and choose these four columns:

- - *Coll*

- - *Call no.*

- - *Author*

- - *Title*

If your site holds multiple copies of items then you will need to select *Barcode* too.

</td><td rowspan="5" style="width: 57.7319%; vertical-align: middle; border-style: none;">![Pop-up box that lets the user choose which columns to display in the Pull List window, with the first 4 columns highlighted](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/zJQq4jUHPaI1G4oU-Pull-List-Display-Options.PNG)</td></tr></tbody></table>

Click on **OK** and the list will look a lot tidier, and can now be printed with one item per line:

![The Pull List, with results sorted by collection, call number, author and title](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/c590JRS3r5uN9hSF-Pull-List-Tidy.PNG)

When you have printed the list click on **Keep List**.  This will make sure that items keep appearing in the list until you have found them and checked them in.

Click on **Yes** when this pop-up appears:

![Pop-up message which confirms that the user wants to keep the list of pulled items](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/HCuGaMKms3UT1EKS-Confirm-Keep-List.PNG)

<p class="callout danger">**Never click on List Pulled.**  This will delete everything from from the list for the next 24 hours.</p>

<p class="callout danger">**Never click on Delete Request(s).**  This will cancel all the requests made by borrowers.  If you need to delete a request for a borrower, do that from the Borrower’s Request List.  See the section *[Requests and Holds](https://documentation.nlpl.ca/link/6#bkmrk-page-title)*.</p>

When you have found the items check them in.  Horizon will tell you who to place each item on hold for.

If you cannot find an item in the list, then after a few days you will need to change its status to *trace*.  See the section [<span style="color: #000080;">*Adding and Editing items*</span>](https://documentation.nlpl.ca/books/horizon-guide/page/adding-editing-items).

---

### Expired and Cancelled Holds

<iframe allowfullscreen="allowfullscreen" height="315" src="//www.youtube.com/embed/QX8dZg04QQg" width="562"></iframe>

The Expired and Cancelled Holds Report provides a list of items being held that the borrowers have not picked up on time.  The items need to be removed from the holds shelf and checked in.  Horizon will then tell you if the item needs to be held for another borrower, placed in transit, or re-shelved.

<p class="callout warning">This report must be generated daily, and at smaller sites it may often be empty.</p>

To generate the report:

- - - open Circulation Reports
        - select from top menu **Requests &gt; Expired/Canceled**

![List of expired and cancelled holds](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/PStMan1N3joC0zDY-Expired-&-Cancelled-Holds.PNG)

Remove the items from the holds shelf and check them in.  If an item cannot be found on the holds shelf then check the regular shelving.  If an item is not there either then you will need to set its status to *trace* using the Item Status Editor.  See the section [<span style="color: #000080;">*Adding and Editing items*</span>](https://documentation.nlpl.ca/books/horizon-guide/page/adding-editing-items).

---

### I didn’t have time to run my notices today!

Generate and output them as soon as you can.  Horizon will generate all notices that should have been sent since you last ran notices.

<p class="callout warning">Be aware that running notices late gives borrowers less notice about items that are almost due back and items that are being held for them.</p>

---

## Online Stats

<p class="callout info">Every day you need to submit circulation and activity statistics for your site.</p>

This is done through the <span style="text-decoration: underline;">[Library Stats System](https://stats.nlpl.ca/)</span>.  Some of the stats are automatically completed by Horizon, and they appear in gray.  Some stats have to be completed manually, and they appear in blue or yellow:

![Example of daily stats for a location](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/iPEkVv9OSn3dbV1q-Daily-Stats.PNG)

---

## Item Report

<iframe allowfullscreen="allowfullscreen" frameborder="0" height="315" src="https://www.youtube.com/embed/Oe8r_tcr0oo" width="560"></iframe>

Item Report is useful for managing your collections.  You ask it to search for items in a particular collection, status, and location and it will return a list of results.

As examples, it can provide lists of all items that:

- - - are currently checked out
        - have not been checked out in the last 4 years (or any other time period)
        - are in the Adult Fiction NL collection
        - need to be traced
        - are on order for your location

<p class="callout info">You can *compound* the search, meaning that you can ask it to search based on 2 or more conditions.</p>

For example, a search *for ‘items that need to be traced from the DVD location at Bay Roberts’* will use 3 conditions:

<table border="1" id="bkmrk-%C2%A0-status-is-%E2%80%98trac" style="border-collapse: collapse; width: 51.2178%;"><tbody><tr><td style="width: 7.21143%; border-style: none;"> </td><td style="width: 44.0275%; border-style: none;"><span style="color: #3366ff;">status is *‘trace’*</span>

<span style="color: #339966;">AND</span>

<span style="color: #3366ff;">item type is *‘dvd’*</span>

<span style="color: #339966;">AND</span>

<span style="color: #3366ff;">location is *‘abr’*</span>

</td></tr></tbody></table>

See *[<span style="color: #000080;">Compound Search</span>](https://documentation.nlpl.ca/books/horizon-guide/page/reports#bkmrk-compound-search)* for how to do this.

You can print the list of results, and you can also sort the list by collection and call number, which will help when you are searching the shelves for items.

<table border="1" id="bkmrk-item-report-is-opene" style="border-collapse: collapse; width: 100%; height: 67px;"><tbody><tr style="height: 77px;"><td colspan="2" style="vertical-align: top; border-style: none; height: 67px; width: 61.9588%;">Item Report is opened by clicking on ![Item Report button](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/wALabFixPHeoXGUo-Item-Report-Button.png), or it can be found in the navigation bar:</td><td style="width: 41.8558%; border-style: none; height: 67px;">![Item Report option selected in the navigation bar](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/vqBSVWRwAkR5h7uy-Item-report-Select.PNG)

</td></tr></tbody></table>

Double-click on it to open the compound search box:

![Pop-up box that lets the user perform a compound search for items](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/RofIE3rDgjUx8IRk-Compound-Search-Box.PNG)

Select an index in the top half of the box and then type in the code for it in the *‘Search for’* field.  Click on **Search** to see the list of results.

If you don’t know what code to use then click on **Show Codes**:

![Pop-up box that lets the user find and select a code to use when searching](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/xKn9tsDwNaRnQG4J-Code-Lookup.PNG)

---

Simple example: find all items belonging to a location

To find all items belonging to Trepassey (ATY):

- - - select the index <span style="color: #000000;">'Loc'</span>
        - in the *Search for* field, enter the code <span style="color: #000000;">‘aty’</span>

These are the results:

![List of results in Item Report window, showing all the items at a location](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/51xfEzipwzgF62eI-Item-Report---All-Items-at-Location.PNG)

Clicking on **Display** lets you choose which information to display for each item, which is useful if you need to print the list.

Keep the columns highlighted that you want to display:

![Pop-up box that lets the user choose which columns to display in the Item Report window](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/Ha8DDeiRq1xklzUi-Item-Report-Display-Options.PNG)

The list is now clearer to read:

![List of results in Item Report window, with only selected columns displayed](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/RGhPbmUWQ1vUMZhL-Item-Report-Choose-Columns-to-Display.PNG)

It can also help to sort the list, by collection and into alphabetical order.  Click on **Display** and choose what to order by:

![Pop-up that lets the user choose the order in which search results are displayed](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/ElDLq4i5OzdcJ8C7-Choose-Sort-Columns.PNG)

…and the list is now sorted, and good to print:

![List of results in Item Report window, sorted by collection and title](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/5tOl5Vr1lnHqQ5fF-Item-Report---Sorted-List.PNG)

---

### Compound Search

To search using more than one condition you need to:

- - - select the <span style="color: #0000ff;">first index to search</span>
        - enter the <span style="color: #0000ff;">first condition</span>
        - select <span style="color: #006600;">AND </span>or<span style="color: #006600;"> OR</span>
        - select the <span style="color: #0000ff;">second index to search</span>
        - enter the <span style="color: #0000ff;">second condition</span>, and so on

---

Compound Example: find items on order for your location

<table border="1" id="bkmrk-%C2%A0-select-the-index-" style="border-collapse: collapse; width: 100%;"><tbody><tr><td rowspan="6" style="width: 50%; vertical-align: top; border-style: none;">

- select the index <span style="color: #0000ff;">S*tatus*</span>

- enter <span style="color: #0000ff;">‘*r*’</span> into the *Search for* field

- select <span style="color: #006600;">AND</span>

- select the index<span style="color: #0000ff;"> *Loc*</span>

- enter the 3 letter code for your location (for example <span style="color: #0000ff;">*'amp'*</span> for Mount Pearl)

- click on **Search**

</td><td rowspan="6" style="width: 50%; border-style: none;">![Flow of work showing how to create a compound search](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/G5Kq7llfBKVCn4TQ-Compound-Search-%5BEdited%5D.PNG)</td></tr></tbody></table>

…and here are the results:

![List of results for a compound search](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/rGkgKSxrHtlamS2D-Compound-Search-Results.PNG)

---

Compound Example: listing items needing to be traced at your location

- - - select the index <span style="color: #0000ff;">S*tatus*</span>
        - enter ‘*trace*’ into the <span style="color: #0000ff;">*Search for*</span> field
        - select <span style="color: #006600;">AND</span>
        - select the index <span style="color: #0000ff;">*Loc*</span>
        - enter the 3 letter code for your location (for example <span style="color: #0000ff;">*'amp'*</span> for Mount Pearl)
        - click on **Search**

---

### Cancelling a Search

If you decide to cancel a search this pop-up message will appear:

![Pop-up message asking if the user wants to load all rows](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/50P3RVH4ZOSNfBk9-Load-All-Rows-Pop-up.PNG)

<p class="callout warning">Click on **Cancel**, otherwise Horizon will try to fetch the entire database of items.</p>

Press **\[Esc\]** to close the Item Report window.

---

## Adhoc Stat Reports

Horizon can generate detailed reports, such as a breakdown of how many items are in each collection at a site, or how much revenue was taken in lost and late fees over a chosen period.

These reports are generated by the Adhoc Stats Report feature found in the navigation bar:

![The Adhoc Stat Reports option selected in the navigation bar](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/EXCzzZhOxtswRfE6-Adhoc-Stats-Reports-Select.PNG)

Double-click on Adhoc Stats Reports to open the generator box.  Select:

- - - the *type* of report
        - one or more *locations* to generate it for
        - if you have chosen a daily report then also enter a date in the *Date* field

<p class="callout info">If you are not working at Bell Island then deselect that location before selecting your site</p>

![Pop-up box that lets the user select which Adhoc Statistical Report to generate](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/jsWDa1MDDLndcIdU-Adhoc-Stats-Report-Generator.PNG)

In the example above the monthly Collection Snapshot report is going to be generated for Bay Roberts (ABR).

Click on **Save to File** if you want to keep the report.

<p class="callout info">To open the saved file use *Wordpad* or *Notepad* because both programs retain the column formatting.</p>

A monthly collection snapshot looks like this:

![Example of a collection snapshot report for a location](https://documentation.nlpl.ca/uploads/images/gallery/2019-04-Apr/scaled-840-0/0YjGhM3s5llkL4R5-Collection-Snapshot-Output.PNG)

The report can run to several pages and provides a comprehensive breakdown of how many items are in each collection, as well as how many items were in the collections 1 month ago and 1 year ago.

The descriptions are truncated, so some can be slightly cryptic – for example in<span style="color: #000000;"> ‘Adult Fiction A’</span>, the <span style="color: #000000;">‘A’</span> is for <span style="color: #000000;">‘Audio’</span>.  Similarly <span style="color: #000000;">‘B’</span> is for <span style="color: #000000;">‘Blu-Ray’</span>, <span style="color: #000000;">‘D’</span> is for <span style="color: #000000;">‘DVD’</span> and so on.

Also, be aware that the report lists how many items per collection Horizon has recorded for your site.

<p class="callout warning">This can differ from reality if weeded books were not discarded in Horizon, or if books have gone missing without staff being aware.</p>

The Item Report feature can be used to list exactly which items Horizon has recorded for the collections at your location.