The latest release is 3.2.5 and 3.2.6 is due in less than 10 days, you might want to consider upgrading :) <br><br>Nicole<br><br><div class="gmail_quote">On Tue, Mar 15, 2011 at 3:21 PM, Peel Lisa <span dir="ltr"><<a href="mailto:lisa.peel@ritz.edu">lisa.peel@ritz.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="FR-CH">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Hi Nicole</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-GB">Still on 3.00 I am afraid !</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-GB"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-GB">Lisa</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-GB"> </span></p>
<p class="MsoNormal"><b><span style="font-size: 10pt;" lang="EN-US">From:</span></b><span style="font-size: 10pt;" lang="EN-US"> Nicole Engard [mailto:<a href="mailto:nengard@gmail.com" target="_blank">nengard@gmail.com</a>]
<br>
<b>Sent:</b> 15 March 2011 20:11<br>
<b>To:</b> Peel Lisa<br>
<b>Cc:</b> <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a><br>
<b>Subject:</b> Re: [Koha] Creating a report for serials</span></p><div><div></div><div class="h5">
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">Lisa,<br>
<br>
My list of claims is showing me the branch code. What version of Koha are you using?<br>
<br>
Nicole</p>
<div>
<p class="MsoNormal">2011/3/15 Peel Lisa <<a href="mailto:lisa.peel@ritz.edu" target="_blank">lisa.peel@ritz.edu</a>></p>
<div>
<div>
<p class="MsoNormal">Hello all</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span lang="EN-GB">We have had our serials module live for about 6 months now so I thought it was about time I looked at the Claims – however, it does not tell me which library
each subscription is for so it is difficult for me to know which missed/late serials to direct to which library.</span></p>
<p class="MsoNormal"><span lang="EN-GB"> </span></p>
<p class="MsoNormal"><span lang="EN-GB">Could someone perhaps provide me with the SQL to run a report which will give me the information which Claims gives me but also with the added information of
Library (Claims currently gives me Supplier, Title, Issue Number, Status, and Since). I normally try and tweak one of the reports in the SQL Reports Library but I cannot find any for the Serials module.</span></p>
<p class="MsoNormal"><span lang="EN-GB"> </span></p>
<p class="MsoNormal"><span lang="EN-GB">Thanks in advance.</span></p>
<p class="MsoNormal"><span lang="EN-GB"> </span></p>
<p class="MsoNormal"><span lang="EN-GB">Regards</span></p>
<p class="MsoNormal"><span lang="EN-GB"> </span></p>
<p class="MsoNormal"><span lang="EN-GB">Lisa</span></p>
<p class="MsoNormal"><span lang="EN-GB"> </span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;">
<span style="color: black;"><img src="cid:image001.jpg@01CBE34E.9C3D5310" alt="Description: Description: Description: CR_logo_POS_COULEUR b" border="0" height="51" width="227"></span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;">
<b><span style="color: black;" lang="EN-US"> </span></b></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;">
<b><span style="color: black;" lang="EN-US"> </span></b></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;">
<b><span style="color: black;">LISA PEEL, PGDip, MA.</span></b></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;">
<span style="color: black;">Librarian</span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;">
<span style="color: black;">César Ritz Colleges Switzerland</span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;">
<span style="color: black;">1897 Le Bouveret - Switzerland</span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;">
<span style="color: black;" lang="EN-US">Tel: <a href="tel:%2B41%2024%20482%2082%2082" target="_blank">
</a><a href="tel:%2B41%2024%20482%2082%2082" target="_blank">+41 24 482 82 82</a> Fax: <a href="tel:%2B41%2024%20482%2082%2080" target="_blank">
</a><a href="tel:%2B41%2024%20482%2082%2080" target="_blank">+41 24 482 82 80</a></span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;">
<span style="color: black;" lang="EN-US">E-mail: <b><a href="mailto:hortense.hofer@ritz.edu" target="_blank">lisa.peel@ritz.edu</a></b></span></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;">
<span style="color: black;" lang="EN-US"><a href="http://www.ritz.edu/" target="_blank">http://www.ritz.edu</a> -
<a href="http://www.culinaryarts.ch/" target="_blank">http://www.culinaryarts.ch</a></span></p>
<p class="MsoNormal"> </p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a></p>
</div>
<p class="MsoNormal"> </p>
</div></div></div>
</div>
</blockquote></div><br>