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: manojmisrasrm...@gmail.com On Fri, Apr 11, 2014 at 4:48 AM, Katelyn Browne [via Koha] < ml-node+s1045719n5793778...@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. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha