I've seen the report that gives you all checked out books, but I then have to go through each title and see if we have any copies that are not checked out.
I've also seen the one that tells you books with copies on hold, but our patrons tend to do a lot of dropping in to see if we have something rather than placing holds. I'm just wondering if someone has written a report that is not on the SQL Reports Library that finds titles with every copy checked out. If not, I may try writing one, but I've never written a report before so I thought I'd try this first. Thanks, Caitlin Kleinpaste On Fri, Aug 21, 2015 at 7:38 PM, Indranil Das Gupta <[email protected]> wrote: > Hi Caitlin, > > On Sat, Aug 22, 2015 at 1:49 AM, Caitlin Kleinpaste > <[email protected]> wrote: > > We're trying to get an idea of books that we might need more copies of, > and > > so want to get a list of all the titles we have that all copies are > checked > > out. > > > > Has anyone written a report like this? If so, could you send it to me? > > > http://wiki.koha-community.org/wiki/SQL_Reports_Library#All_Checked_Out_Books > > And while you are at it, also take a look at the other reports :-) > > hope this helps, > -Indranil > > > -- > Indranil Das Gupta > L2C2 Technologies > > Phone : +91-98300-20971 > Blog : http://indradg.randomink.org/blog > IRC : indradg on irc://irc.freenode.net > Twitter : indradg > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- > Please exchange editable Office documents only in ODF Format. No other > format is acceptable. Support Open Standards. > > For a free editor supporting ODF, please visit LibreOffice - > http://www.documentfoundation.org > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
