[Koha] Reports returning different totals

Cindy Weber cweber at scls.lib.wi.us
Fri May 6 06:59:41 NZST 2011

Thank you for the explanation!  Between your explanation and Beverly 
Church's I've managed to figure out the problem.  The top report listed 
the checkouts by the home library of the patron, not the checkout 
library so that was part of the issue.  The other is we do appear to be 
affected by the reporting bug as well.  There are thousands of renewals 
that show as having no agency code so they weren't included in the 
second report totals. 

Is there someplace else to get the renewal information?  I would think 
issues.lastrenewdate and old_issues.lastrenewdate would get me some of 
them but not if the item had been renewed twice.


Owen Leonard wrote:
>> We recently went live and I'm now trying to run the monthly statistics
>> reports I've set up.  One of the reports is to total the number of
>> checkouts and renewals for the month listed by library and the other is
>> the same total number of checkouts and renewals but listed by the
>> borrower category code.
> In Koha there is a bug which causes renewals to be recorded in the
> statistics table with no branch code. I don't know if PTFS's fork has
> a fix for this, but it sounds like that is a likely cause. Pending a
> solution I've been including a report of circulations with no branch
> alongside the other branch stats.
>   -- Owen

Cindy Weber                       cweber at scls.lib.wi.us
System Support Specialist         (608)242-4710
South Central Library System    

More information about the Koha mailing list