[Koha] Report Help

[manoj382093]

Thank you very much Katelyn, it worked.

*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 Fri, Apr 11, 2014 at 4:48 AM, Katelyn Browne [via Koha] <
ml-node+s1045719n5793778h89 at n5.nabble.com> wrote:

> Liz's report should do what you want if you change the GROUP BY to say
> "GROUP BY biblionumber, i.itype." (That will list, say, the 14 copies of
> Book A that are type x, then the 3 copies that are type y. If you'd rather
> have all the type x's list together, then all the type y's, just change
> the
> order: GROUP BY i.itype, biblionumber).
>
> --Katelyn.
>
> Katelyn Browne
> Middle/High School Librarian
> Capital City Public Charter School
> 100 Peabody Street NW
> Washington, DC 20011
> (202) 387-0309 x1745
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5793778&i=0>
> http://www.ccpcs.org/library/
>
>
> On Fri, Apr 11, 2014 at 3:47 AM, manoj382093 <[hidden email]<http://user/SendEmail.jtp?type=node&node=5793778&i=1>>wrote:
>
>
> > Dear Chitralekha,
> > Take this example:
> > I have one book with 12 copies, 8copies with item type BTECHBKS and 4
> > copies with item type BCABKS. When i generate report it shows 12 copies
> for
> > itemtype BTECHBKS and none for BCABKS.
> >
> > Is there any way of reporting so that i can get the correct report or i
> > would have to remove 4 copies and save it as different bib record.
> >
> > *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: [hidden email]<http://user/SendEmail.jtp?type=node&node=5793778&i=2>
> >
> >
> > On Thu, Apr 10, 2014 at 2:06 AM, Chitralekha [via Koha] <
> > [hidden email] <http://user/SendEmail.jtp?type=node&node=5793778&i=3>>
> wrote:
> >
> > > Please try this SQL report. This is sorted by count.
> > >
> > >
> > > SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/
> detail.pl?biblionumber=
> > ',biblio.biblionumber,'\">',biblio.biblionumber,'</a>')
> > >
> > > AS biblionumbers,
> > >        biblio.author, biblio.title,
> > > COUNT(items.itemnumber) AS ItemCount, ccode, itype
> > > FROM items
> > > LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
> > > GROUP BY items.biblionumber HAVING (COUNT(*)>=1)
> > > ORDER BY ItemCount DESC
> > >
> > >
> > > On Sat, Apr 5, 2014 at 2:01 PM, manoj382093 [via Koha] <[hidden
> email]<
> > http://user/SendEmail.jtp?type=node&node=5793620&i=0>
> > > > 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.
> > >>
> > >> ------------------------------
> > >>  If you reply to this email, your message will be added to the
> > >> discussion below:
> > >> http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html
> > >>  To unsubscribe from Koha-general, click here.
> > >> 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
> > >
> > >>
> > >
> > >
> > >
> > > ------------------------------
> > >  If you reply to this email, your message will be added to the
> discussion
> > > below:
> > > http://koha.1045719.n5.nabble.com/Report-Help-tp5793161p5793620.html
> > >  To unsubscribe from Report Help, click here<
> >
> >
> > > .
> > > 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-tp5793161p5793704.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=5793778&i=4>
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> [hidden email] <http://user/SendEmail.jtp?type=node&node=5793778&i=5>
> 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-tp5793161p5793778.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-tp5793161p5793912.html
Sent from the Koha-general mailing list archive at Nabble.com.