Re: [Koha] Report Help

2014-04-11 Thread 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

Re: [Koha] Report Help

2014-04-11 Thread Katelyn Browne
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

Re: [Koha] errors, migrating from 3.10.04 to 3.14.04

2014-04-11 Thread anjoze
I've made a a fresh install, dumped *koha_koha.authorised_values_branches* Than, imported *koha_koha.authorised_values_branches* to my koha and everything was ok. pAuthorised Values started to work :) - Koha version: 3.08.04 - - José Anjos -- View this message in context:

[Koha] irregular serial numbering

2014-04-11 Thread Giuseppe Angilella
Hi, I'm having trouble in defining the numbering pattern for a serial. The serial is weekly (number icreases by one every new week, and is never reset to one), but the volume number increases at the beginning of each new second month. This means every 7, or 8, or 9 weeks (i.e., issues),

Re: [Koha] Report Help

2014-04-11 Thread 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: manojmisrasrm...@gmail.com On Fri, Apr 11, 2014 at 4:48 AM, Katelyn Browne [via Koha]