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 <[email protected]> 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
> [email protected]
> http://lists.katipo.co.nz/**mailman/listinfo/koha<http://lists.katipo.co.nz/mailman/listinfo/koha>
>
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
