[Koha] Report Help

[manoj382093]

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: manojmisrasrmgpc at gmail.com


On Thu, Apr 10, 2014 at 2:06 AM, Chitralekha [via Koha] <
ml-node+s1045719n5793620h91 at n5.nabble.com> 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<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-tp5793161p5793704.html
Sent from the Koha-general mailing list archive at Nabble.com.