Re: [Koha] Report Help

, 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

Re: [Koha] Report Help

=nodenode=5793778i=0 http://www.ccpcs.org/library/ On Fri, Apr 11, 2014 at 3:47 AM, manoj382093 [hidden email]http://user/SendEmail.jtp?type=nodenode=5793778i=1wrote: Dear Chitralekha, Take this example: I have one book with 12 copies, 8copies with item type BTECHBKS and 4 copies with item

Re: [Koha] Report Help

(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

[Koha] Report Help

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.

Re: [Koha] Report Help

Dear Arslan, I could not find it there *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 Sat, Apr 5, 2014 at 12:39 AM, arslan [via Koha]

Re: [Koha] Sorting of accession numbers

with the number 1) then press enter and then drag the formula to put A back Regards, - Jerwyn On Sat, Mar 29, 2014 at 12:20 PM, manoj382093 [hidden email]http://user/SendEmail.jtp?type=nodenode=5792600i=0wrote: Dear Friends, I have used alphabets in barcode numerbers

Re: [Koha] Circulation and Fine Rules

+s1045719n5790215...@n5.nabble.com wrote: Holger Meissne is correct. You need to define different circulation rules. Vikram Zadgaonkar On Tue, Mar 11, 2014 at 2:21 PM, Holger Meissner [hidden email] http://user/SendEmail.jtp?type=nodenode=5790215i=0 wrote: manoj382093 wrote: Dear Friends, I am

[Koha] Circulation and Fine Rules

Dear Friends, I am testing latest version of koha for my library, I have set five item types for different courses and five different patron categories of these courses. I have set same course patron category with item type so that patrons cannot get books of other courses. but it is not working