[Koha] Creating a report for serials

[Nicole Engard]

The latest release is 3.2.5 and 3.2.6 is due in less than 10 days, you might
want to consider upgrading :)

Nicole

On Tue, Mar 15, 2011 at 3:21 PM, Peel Lisa <lisa.peel at ritz.edu> wrote:

>  Hi Nicole
>
>
>
> Still on 3.00 I am afraid !
>
>
>
> Lisa
>
>
>
> *From:* Nicole Engard [mailto:nengard at gmail.com]
> *Sent:* 15 March 2011 20:11
> *To:* Peel Lisa
> *Cc:* koha at lists.katipo.co.nz
> *Subject:* Re: [Koha] Creating a report for serials
>
>
>
> Lisa,
>
> My list of claims is showing me the branch code. What version of Koha are
> you using?
>
> Nicole
>
> 2011/3/15 Peel Lisa <lisa.peel at ritz.edu>
>
> Hello all
>
>
>
> 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.
>
>
>
> 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.
>
>
>
> Thanks in advance.
>
>
>
> Regards
>
>
>
> Lisa
>
>
>
> [image: Description: Description: Description: CR_logo_POS_COULEUR b]
>
> * *
>
> * *
>
> *LISA PEEL, PGDip, MA.*
>
> Librarian
>
> César Ritz Colleges Switzerland
>
> 1897 Le Bouveret - Switzerland
>
> Tel:  <%2B41%2024%20482%2082%2082>+41 24 482 82 82 Fax: <%2B41%2024%20482%2082%2080>+41
> 24 482 82 80
>
> E-mail: *lisa.peel at ritz.edu <hortense.hofer at ritz.edu>*
>
> http://www.ritz.edu - http://www.culinaryarts.ch
>
>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110315/76fa3a3a/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 4030 bytes
Desc: not available
Url : http://lists.katipo.co.nz/pipermail/koha/attachments/20110315/76fa3a3a/attachment-0001.jpeg