[Koha] Koha reports

[MJ Ray]

On 03/07/13 09:22, Evan Mungai Njoroge wrote:
> I want to get a report of all my overdue books; I ran the report yesterday
> got the printout verified with the shelves and returned a number of books.
> Running the report again today; I expectedit to remove the patrons who have
> already returned them but I can still see them on the list. Kindly help.
> 
> This is the report I used.

(Full report at
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Overdue_materials )

I think that WHERE maybe should start "WHERE items.onloan IS NOT NULL
AND ..." - anyone using this report like to comment?

Thanks,
-- 
MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op
http://koha-community.org supporter, web and library systems developer.
In My Opinion Only: see http://mjr.towers.org.uk/email.html
Available for hire (including development) at http://www.software.coop/