Lisa,<br><br>My list of claims is showing me the branch code. What version of Koha are you using?<br><br>Nicole<br><br><div class="gmail_quote">2011/3/15 Peel Lisa <span dir="ltr"><<a href="mailto:lisa.peel@ritz.edu">lisa.peel@ritz.edu</a>></span><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">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="font-size: 12pt; color: black;"><img src="cid:image001.jpg@01CBE34A.E998A050" alt="Description: Description: Description: CR_logo_POS_COULEUR b" height="51" width="227"></span><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;" 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><b><span style="font-size: 12pt; font-family: "Times New Roman","serif"; color: black;"></span></b></p>
<p class="MsoNormal" style="margin-left: 18pt; line-height: 12pt;">
<span style="color: black;">Librarian</span><span style="color: black;"></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">+41 24 482 82 82</a> Fax: <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"><span style="color: blue;">lisa.peel@ritz.edu</span></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"><span style="color: blue;">http://www.ritz.edu</span></a> -
<a href="http://www.culinaryarts.ch/" target="_blank"><span style="color: blue;">http://www.culinaryarts.ch</span></a></span></p>
<p class="MsoNormal"> </p>
</div>
</div>
<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">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><br>
<br></blockquote></div><br>