[Koha] Circulation report

[Susan Bennett]

I run the following report monthly to get checkouts and renewals, changing
the dates of course. You may need to change some of the field names since
I'm on one of the PTFS versions.

SELECT items.ccode AS Collection, COUNT( statistics.itemnumber ) AS Count,
Branch AS BRANCH FROM statistics LEFT JOIN items ON (statistics.itemnumber
= items.itemnumber) WHERE statistics.type IN ('issue')  AND
year(statistics.datetime) = '2012' and month(statistics.datetime) = '01'
GROUP BY branch, items.ccode

SELECT items.ccode AS Collection, COUNT( statistics.itemnumber ) AS Count,
Branch AS BRANCH FROM statistics LEFT JOIN items ON (statistics.itemnumber
= items.itemnumber) WHERE statistics.type IN ('renew')  AND
year(statistics.datetime) = '2012' and month(statistics.datetime) = '01'
GROUP BY branch, items.ccode

Susan Bennett
ILS System Administrator
Geauga County Public Library
440 286-6811 x 125
440 286-7419 FAX


On Thu, Feb 16, 2012 at 6:55 AM, Bob Birchall <bob at calyx.net.au> wrote:

> On 16/02/12 22:48, alaa Badri wrote:
>
>> How to get report for All Circulation Actions on Range Date
>>
> Have you read the manual?  Its at http://koha-community.org/**
> documentation/ <http://koha-community.org/documentation/>
> You may get the information you are seeking from the Log Viewer on the
> Tools menu.
>
>>
>> Please help urgent
>>
>>
> The people on the list give their time voluntarily to answer questions and
> it is not always possible to answer promptly.  However if you take the time
> to study the manual, you'll find its full of great information.
>
> Best wishes for your use of Koha.
>
> Bob Birchall
> Calyx
>
> ______________________________**_________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/**mailman/listinfo/koha<http://lists.katipo.co.nz/mailman/listinfo/koha>
>