Dear Vishal Patil, thank you for the assistance. The school did use the 'Patrons checking out the most' report and then copied and paste the reading history into a spreadsheet to produce the information they needed, it's just that they were hoping for a solution that required a little less intervention. I should have provided more information in my initial request for help. My apologies. I appreciate you taking the time to help. Best wishes, Clint. vishal patil wrote:
Hii,
Visit koha report library for any sql report:
http://wiki.koha-community.org/wiki/SQL_Reports_Library
On Mon, Sep 22, 2014 at 12:38 PM, clint.deckard <clint.deckard@frontiers.co.nz <mailto:clint.deckard@frontiers.co.nz>> wrote:
A school I deal with would like a report that lists the reading history of the top 10 borrowers so that they can award a prize to each. As I am not a sql expert I would appreciate some assistance. Much appreciated, Clint.
-- Clint Deckard Takapau Central Hawkes Bay, New Zealand.
_________________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/__mailman/listinfo/koha <http://lists.katipo.co.nz/mailman/listinfo/koha>
-- *Warm Regards, Vishal Patil *Software Engineer - Nucsoft Ltd. phone: 022 32080161 | mob: 08767505528 www.osslabs.biz <http://www.osslabs.biz/> www.nucsoft.com <http://www.nucsoft.com/> vishal.patil@osslabs.biz <mailto:vishal.patil@osslabs.biz>