[Koha] Report for titles with all copies checked out

[Caitlin Kleinpaste]

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

> Hi Caitlin,
>
> On Sat, Aug 22, 2015 at 1:49 AM, Caitlin Kleinpaste
> <kleinpastec at xenos.org> 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
>