[Koha] Report Help

[manoj382093]

Thanks Liz, it is working but i want list with specific item type and
collection code. As the bib record may be attached to more than 1 item type
so it should be distinct.

*Regards!*

*Manoj Kumar Misra*
M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.)
Deputy Librarian
SRMGPC
Lucknow
Mob. No.: 09415422579
Alternate E-mail: manojmisrasrmgpc at gmail.com


On Sun, Apr 6, 2014 at 5:09 PM, Liz Rea-3 [via Koha] <
ml-node+s1045719n5793227h8 at n5.nabble.com> wrote:

> Give this a try:
>
> SELECT b.title, count(i.itemnumber) AS "number of items", i.itype,
> i.ccode FROM biblio b JOIN items i USING(biblionumber) GROUP BY
> b.biblionumber
>
> If it works you can add it to the report library. ;)
>
> Cheers,
> Liz Rea
> Catalyst IT
>
> On 05/04/14 21:31, manoj382093 wrote:
>
> > Dear Friends,
> >  I am looking for a report which has list of titles(biblio) their number
> of
> > copies(items) by item type and collection code.
> >
> >
> >
> > --
> > View this message in context:
> http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html
> > Sent from the Koha-general mailing list archive at Nabble.com.
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > [hidden email] <http://user/SendEmail.jtp?type=node&node=5793227&i=0>
> > http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5793227&i=1>
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
> http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793227.html
>  To unsubscribe from Report Help, click here<http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5793161&code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkzMTYxfC0xMDkzNzg1MDg0>
> .
> NAML<http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>




--
View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793244.html
Sent from the Koha-general mailing list archive at Nabble.com.