[Koha] Report for titles with all copies checked out

[Ahmad Amanullah Khan]

Good Morning

We have setup overdue notices and slips but unable to send emails. Email is
working when creating a new patron account. Please help

On Sun, Aug 23, 2015, 5:12 PM Caitlin Kleinpaste <kleinpastec at xenos.org>
wrote:

> 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
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>