[Koha] Report help- reading history

2014-09-22 Thread clint.deckard
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.

Re: [Koha] Report help- reading history

2014-09-22 Thread vishal patil
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.deck...@frontiers.co.nz> wrote: > A school I deal with would like a report that lists the reading history of > the top 10 borrowers

Re: [Koha] Report help- reading history

2014-09-22 Thread clint.deckard
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 inte

Re: [Koha] Report help- reading history

2014-09-22 Thread Katelyn Browne
Clint, This is SUPER rough and cobbled-together, but it's the best I could do in a few minutes. If I have time later, I'll try to clean it up a bit (or others are welcome to do so). I have NOT tested it very extensively! It doesn't show multiple checkouts of the same item by the same patron, but