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@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@lists.katipo.co.nz http://lists.katipo.co.nz/**mailman/listinfo/koha<http://lists.katipo.co.nz/mailman/listinfo/koha>