<div dir="ltr">Hi Chris,<div><br></div><div>I think I would start with the Bibliographic Records source and link to the Call Numbers source and, from there, to the Owning Library to get the org units.</div><div><br></div><div>In addition to the Org Unit and (bibliographic record?) date filters I would include these filters:</div><div><br></div><div><table cellspacing="0" cellpadding="0" dir="ltr" border="1" style="table-layout:fixed;font-size:10pt;font-family:Arial;width:0px;border-collapse:collapse;border:none"><colgroup><col width="137"><col width="100"><col width="100"></colgroup><tbody><tr style="height:21px"><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)">Source</td><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)">Field</td><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)">Value</td></tr><tr style="height:21px"><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)"></td><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)"></td><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)"></td></tr><tr style="height:21px"><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)">Bibliographic Records</td><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)">Is deleted?</td><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)">FALSE</td></tr><tr style="height:21px"><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)"><br></td><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)"></td><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)"></td></tr><tr style="height:21px"><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)">Call Numbers</td><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)">ID</td><td style="overflow:hidden;padding:2px 3px;vertical-align:bottom;border:1px solid rgb(204,204,204)">is Null</td></tr></tbody></table><br></div><div>I suspect you will want to use a Date transform for the date field.</div><div><br></div><div>I don't actually have a report template like this, but have attached screenshots of how I would start off.</div><div><br></div><div>I only looked at this quickly, so I am not certain this will get you the data you are looking for. It may be a starting place, though.</div><div><br></div><div>Beth</div><div><br></div><div><br></div><div><br></div><div> <br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jun 7, 2021 at 2:44 PM Christopher Bocchinfuso <<a href="mailto:cbocchinfuso@niagaracollege.ca">cbocchinfuso@niagaracollege.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-CA" style="overflow-wrap: break-word;">
<div class="gmail-m_-2038955834817243170WordSection1">
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif">Hello Evergreen Reports Group,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif">My library’s cataloguer asked for a report that generates a list or count of all our library’s bibliographic records with no holdings (empty records). We are part of an Evergreen consortium
group called (LiNC) <a href="https://niagaracollege.niagaraevergreen.ca/eg/opac/home" target="_blank">
Libraries in Niagara Cooperative</a>.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif">I only want to filter by organizational unit and dates for Niagara College Libraries. I can usually filter things well, but I’m unsure which Core Source to start with “bibliographic records”
or ‘Item” or “Call Number/Volume” to get the right data to populate my fields correctly.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif">Does anyone have advice on how I should approach this? Or perhaps you have a report template to share with me?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif">I’m an intermediate-level Evergreen user and I want to expand/continue learning my reporting tool experience and knowledge by building template reports.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif">Thank you for your help!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif">Chris <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Segoe UI",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Segoe UI",sans-serif;color:rgb(89,89,89)">*Due to the COVID-19 pandemic I am working remotely during virtual library hours. Emailing me is the best option during this time.
To schedule a call via MS Teams, BB Ultra Collaborate or Zoom, please send me an email.*</span><span lang="EN-US" style="font-size:10pt;font-family:"Segoe UI",sans-serif;color:rgb(89,89,89)"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12pt;font-family:"Segoe UI",sans-serif">Chris Bocchinfuso,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12pt;font-family:"Segoe UI",sans-serif">Library Facilitator: user experience<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12pt;font-family:"Segoe UI",sans-serif">Welland Campus Library, SE 206<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12pt;font-family:"Segoe UI",sans-serif">905 735 2211, e. 7731<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12pt;font-family:"Segoe UI",sans-serif"><a href="mailto:cbocchinfuso@niagaracollege.ca" target="_blank">cbocchinfuso@niagaracollege.ca</a><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:12pt;font-family:"Segoe UI",sans-serif"><a href="https://nclibraries.niagaracollege.ca/library" target="_blank">https://nclibraries.niagaracollege.ca/library</a><u></u><u></u></span></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt;font-family:"Segoe UI",sans-serif">*
<a href="https://nclibraries.niagaracollege.ca/library" target="_blank">Virtual Chat Help</a> & Text to Chat 289 802 2275. *<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Segoe UI",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Segoe UI",sans-serif">This email contains confidential information intended for the recipient(s). Please do not make this information publicly available without written consent
from Niagara College or the person(s) to whom this email is intended.</span><span><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org" target="_blank">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" rel="noreferrer" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr">Beth Willis
<br>Digital & Catalog Librarian
<br>NOBLE, Inc.
<br>42 Cherry Hill Drive
<br>Danvers, MA 01923 </div></div></div></div>