<div dir="ltr">Glad you found the answer! I had completely forgotten about the claims returned count. Nice. <div><br></div><div>I actually ran into all sorts of problems trying to filter for CLAIMSRETURNED in many of the sources. I was only successful using CLAIMSRETURNED as a filter using the Item Source - all other sources I tried caused various problems. I'll save troubleshooting those problems for another day.<div style>
<br></div><div style>Cristina</div><div style><br></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jun 24, 2013 at 11:56 AM, Jennifer Bielewski <span dir="ltr"><<a href="mailto:jennifer.bielewski@lyrasis.org" target="_blank">jennifer.bielewski@lyrasis.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi Christina, <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Thank you for your response & help. Funny, I just found my answer & confirmed that is shows the correct data. The attachment shows the report template that I have created. There is a source called claims returned count. This will do the trick!<u></u><u></u></span></p>
<div class="im"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d">Jennifer Bielewski<br>
Digital Technology Services Representative<br>LYRASIS<br><u><a href="mailto:jennifer.bielewski@lyrasis.org" target="_blank">jennifer.bielewski@lyrasis.org</a></u></span><span style="font-size:11.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d"><br>
</span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d"><a href="tel:800.999.8558%20x%203848" value="+18009998558" target="_blank">800.999.8558 x 3848</a> Main<br>
<a href="tel:770-548-1698" value="+17705481698" target="_blank">770-548-1698</a> Cell<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d">viannin Skype<br>
</span><span style="font-size:11.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d"><a href="http://www.lyrasis.org/" target="_blank"><span style="font-size:10.0pt">www.lyrasis.org</span></a></span><span style="font-size:16.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:16.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p></div><p class="MsoNormal" style="margin-left:.5in"><a href="http://www.lyrasis.org/" target="_blank"><b><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d;text-decoration:none"><img border="0" width="140" height="46" src="cid:image001.png@01CE70D1.B86A67E0" alt="cid:image001.png@01CE1341.AA604180"></span></b></a><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><br>
<br></span><b><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d"><u></u><u></u></span></b></p><div class="im"><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d">Going Digital? Please ask me about </span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><a href="http://www.lyrasis.org/Products-and-Services/LYRASIS-Digital.aspx" target="_blank"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif"">LYRASIS Digital</span></a></span><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d">.<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:10.0pt;font-family:"Franklin Gothic Book","sans-serif";color:#1f497d"><u></u> <u></u></span></p></div><p class="MsoNormal" style="margin-left:.5in">
<a href="http://www.facebook.com/pages/Lyrasis/148102075244" target="_blank"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";text-decoration:none"><img border="0" width="24" height="24" src="cid:image002.jpg@01CE70D1.B86A67E0" alt="Ficon"></span></a><a href="https://twitter.com/lyrasis" target="_blank"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#1f497d;text-decoration:none"><img border="0" width="23" height="24" src="cid:image003.jpg@01CE70D1.B86A67E0" alt="TIcon"></span></a><span style="font-family:"Arial","sans-serif";color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <a href="mailto:evergreen-reports-bounces@list.evergreen-ils.org" target="_blank">evergreen-reports-bounces@list.evergreen-ils.org</a> [mailto:<a href="mailto:evergreen-reports-bounces@list.evergreen-ils.org" target="_blank">evergreen-reports-bounces@list.evergreen-ils.org</a>] <b>On Behalf Of </b>Cristina Hernandez Trotter<br>
<b>Sent:</b> Monday, June 24, 2013 11:51 AM<br><b>To:</b> Evergreen Community Reports Email List<br><b>Subject:</b> Re: [Evergreen-reports] Claims returned report help<u></u><u></u></span></p><div><div class="h5"><p class="MsoNormal">
<u></u> <u></u></p><div><p class="MsoNormal">Hi, Jennifer,<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">I just wanted to let you know that I am working on your question. During my Saturday shift, I did a little bit of poking around but had no luck getting the aggregate filter to work. I have a couple more things I wanted to try today.<u></u><u></u></p>
</div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">I will let you know if I am successful or not.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">
Keeping fingers crossed,<u></u><u></u></p></div><div><p class="MsoNormal">Cristina<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div><div><p class="MsoNormal" style="margin-bottom:12.0pt">
<u></u> <u></u></p><div><p class="MsoNormal">On Fri, Jun 21, 2013 at 9:59 AM, Jennifer Bielewski <<a href="mailto:jennifer.bielewski@lyrasis.org" target="_blank">jennifer.bielewski@lyrasis.org</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><p class="MsoNormal">Hello Evergreen Reports,<br><br>I'm hoping to find some help with making a report. I'm trying to create a report that shows when a patron has 3 or more claims returned items. I have created a report to show claims returned (stopped fines reasons) but have yet to be successful on adding count in the right place with the correct output.<br>
<br>Thank you for any guidance with this.<br><br><br>Jennifer Bielewski<br>Digital Technology Services Representative<br>LYRASIS<br><a href="mailto:jennifer.bielewski@lyrasis.org" target="_blank">jennifer.bielewski@lyrasis.org</a><br>
<a href="tel:800.999.8558%20x%203848" target="_blank">800.999.8558 x 3848</a> Main<br><a href="tel:770-548-1698" target="_blank">770-548-1698</a> Cell<br>viannin Skype<br><a href="http://www.lyrasis.org" target="_blank">www.lyrasis.org</a><br>
<br><br><br>Going Digital? Please ask me about LYRASIS Digital.<br><br><br>_______________________________________________<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" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><u></u><u></u></p></blockquote></div><p class="MsoNormal">
<u></u> <u></u></p></div></div></div></div></div><br>_______________________________________________<br>
Evergreen-reports mailing list<br>
<a href="mailto:Evergreen-reports@list.evergreen-ils.org">Evergreen-reports@list.evergreen-ils.org</a><br>
<a href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports" target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-reports</a><br>
<br></blockquote></div><br></div>