<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body dir="auto">
You can run a Title/Copy Data report (under the statistic section of Library Reports). You have to enter a call number range, so use whatever prefix you use for fiction (for example, all of ours start with FIC). You then download the file (it comes as .xml
 only) and then you can open it in excel and sort to your needs from there. It contains a lot of information, a lot it you probably won’t need, but it does include all of the information you needed. You can always delete the columns of information you don’t
 need to make it cleaner. 
<div><br>
</div>
<div>There may be another way that I don’t know of, but this is always the report I run when I am unsure of what other report to run! Hope this works for you.</div>
<div><br>
</div>
<div>Paige Niemi</div>
<div>Cataloger</div>
<div>New Trier High School Library</div>
<div><a href="mailto:niemip@nths.net">niemip@nths.net</a></div>
<div>
<div dir="ltr"><br>
On Feb 6, 2020, at 11:26 AM, Wagoner, Benjamin via AISLE <<a href="mailto:aisle@list.railslibraries.info">aisle@list.railslibraries.info</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">Following...</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Feb 6, 2020 at 11:23 AM Melissa Lambert via AISLE <<a href="mailto:aisle@list.railslibraries.info">aisle@list.railslibraries.info</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 dir="ltr"> Hi All,<br>
<div><br>
</div>
<div>I am getting ready to weed my fiction. This year we genrerfied and I just realized I cannot run my usual report to see the number of circulations for each copy in shelf order. I  did not change the call #s on our books. I just put all of our books in sub
 locations for the genre. </div>
<div><br>
</div>
<div>I need to run a report that includes, call #, title, author, sub location, and number of circulations. I tried building a report but I cannot get sub location and number of circulations on the same report. </div>
<div><br>
</div>
<div>Anyone have any suggestions? Thanks for your help!</div>
</div>
MAILMAN_MIMEDEFANG<br>
_______________________________________________<br>
AISLE mailing list<br>
<a href="mailto:AISLE@list.railslibraries.info" target="_blank">AISLE@list.railslibraries.info</a><br>
<br>
For list archives and subscription options, visit:<br>
<a href="http://list.railslibraries.info/cgi-bin/mailman/listinfo/aisle" rel="noreferrer" target="_blank">http://list.railslibraries.info/cgi-bin/mailman/listinfo/aisle</a><br>
<br>
To unsubscribe, send a message to:<br>
<a href="mailto:aisle-leave@list.railslibraries.info" target="_blank">aisle-leave@list.railslibraries.info</a><br>
<br>
<a href="https://www.aisled.org/" rel="noreferrer" target="_blank">https://www.aisled.org/</a></blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div style="text-align:center">
<div style="text-align:left"><span>
<p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><br>
</p>
</span></div>
<div style="text-align:left">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<table style="border:none;border-collapse:collapse">
<tbody>
<tr style="height:105pt">
<td style="border-right:1.5pt solid rgb(115,11,18);vertical-align:middle;padding:5pt">
<p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><img src="https://docs.google.com/uc?export=download&id=18XxlNUtc1JFUr5w6pQMRWMzKX1rPe61X&revid=0ByUq139SZV-aeEM4c1pxWnJ5d3JrTVlBdzBCYVlQc0tLeGZvPQ" width="200" height="198"></span></p>
</td>
<td style="border-left:1.5pt solid rgb(115,11,18);vertical-align:top;padding:5pt">
<p dir="ltr" style="line-height:1.44;text-indent:5pt;margin-top:0pt;margin-bottom:0pt">
<font color="#000000" face="Oswald, sans-serif"><span style="font-size:14.6667px;white-space:pre-wrap"><b>Ben Wagoner</b></span></font></p>
<p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:Poppins,sans-serif;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">  </span><span style="font-size:10pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">LRC
 Director/Media Specialist </span></p>
<p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">St. Charles North High School</span></p>
<p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap"></span></p>
<p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">  255 Red Gate Road, St. Charles,
 IL</span></p>
<p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap"><br>
</span></p>
<p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap">Currently reading: Nyxia by Scott
 Reintgen </span></p>
<p dir="ltr" style="line-height:1.44;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-style:italic;vertical-align:baseline;white-space:pre-wrap"><br>
</span></p>
<p dir="ltr" style="line-height:1.44;text-indent:5pt;margin-top:0pt;margin-bottom:0pt">
<a href="http://district.d303.org/" style="color:rgb(17,85,204)" target="_blank"><span style="font-size:10pt;font-family:Oswald,sans-serif;color:rgb(115,11,18);background-color:transparent;vertical-align:baseline;white-space:pre-wrap">St. Charles CUSD 303</span></a></p>
<p dir="ltr" style="line-height:1.44;text-indent:5pt;margin-top:0pt;margin-bottom:0pt">
<span style="background-color:transparent;color:rgb(0,0,0);font-family:Arial;font-size:10pt;white-space:pre-wrap;text-indent:5pt">331.228.6324</span></p>
<p dir="ltr" style="line-height:1.44;text-indent:5pt;margin-top:0pt;margin-bottom:0pt">
<span style="background-color:transparent;color:rgb(0,0,0);font-family:Arial;font-size:10pt;white-space:pre-wrap;text-indent:5pt"><a href="https://twitter.com/DubOfTheHub" target="_blank">@DuboftheHub</a></span></p>
<p dir="ltr" style="line-height:1.44;text-indent:5pt;margin-top:0pt;margin-bottom:0pt">
<a href="https://twitter.com/StCharlesD303?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor" style="color:rgb(17,85,204);text-indent:0px" target="_blank"><span style="font-size:10pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><img src="https://lh6.googleusercontent.com/tuiU4zAn744IGPVG0stAk0SzvN5B-u-_NpI9dbM6Q3mNDGqam6dkQAI4koMa4KlHbCnxOkqf-TLNt3CKDGxkKbeOzwfLdbhTNADrdWzAIDfA5DLVboLv8oz_lHVOtFepMTW2MXWW" width="22" height="22" style="border: none;"></span></a><a href="https://www.facebook.com/St-Charles-District-303-125824210789789/" style="color:rgb(17,85,204);text-indent:0px" target="_blank"><span style="font-size:11pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><img src="https://lh3.googleusercontent.com/3Ns41ME_GrqNPtUmZ4XF9oamLf3eHqJ5VQobVQtraqCPWcPbHQQDzrytuOvSGCf6cKg6rsNkJjkY1aBw6PpxdSe0KTeXjQZeP1qBwGTslftrYgjAXLRlL1WD0NDCmhOhHPdGnMWA" width="22" height="22" style="border: none;"></span></a><a href="https://www.instagram.com/stcharlesd303/" style="color:rgb(17,85,204);text-indent:0px" target="_blank"><span style="font-size:11pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><img src="https://lh3.googleusercontent.com/YReM9tl1atujF39PMy8lmQV7eL1NeKPEsm7oTXFr19yD5Ytf8XvX_4jJwIDaWNryHqJ2Kg9QVzQIGKCgiM7rlEGLmMjRTsF7qbUf86zs8Hiwl37L4FFaXGMj0mzlTjRGIzRM9qga" width="29" height="22" style="border: none;"></span></a></p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<blockquote type="cite">
<div dir="ltr"><span>MAILMAN_MIMEDEFANG</span><br>
<span>_______________________________________________</span><br>
<span>AISLE mailing list</span><br>
<span><a href="mailto:AISLE@list.railslibraries.info">AISLE@list.railslibraries.info</a></span><br>
<span></span><br>
<span>For list archives and subscription options, visit:</span><br>
<span><a href="http://list.railslibraries.info/cgi-bin/mailman/listinfo/aisle">http://list.railslibraries.info/cgi-bin/mailman/listinfo/aisle</a></span><br>
<span></span><br>
<span>To unsubscribe, send a message to:</span><br>
<span><a href="mailto:aisle-leave@list.railslibraries.info">aisle-leave@list.railslibraries.info</a></span><br>
<span></span><br>
<span><a href="https://www.aisled.org/">https://www.aisled.org/</a></span></div>
</blockquote>
</div>
</body>
</html>