What is the Koha Report Management Tool?

Librarians know that Koha provides the ability to write custom reports using Structured Query Language (SQL)  An understanding of SQL syntax is not too difficult (and certainly worth developing) but you will also need a familiarity with Koha's table structure to use it, and this might take time.  

Koha's Report Builder will hold the user's hand when a simple report is all that's needed, but it often cannot help with the more complex queries that are typically part of library administration.      

Rather than going without, or wasting time reinventing the wheel, a better option is to reuse reports that others have developed where these exist. The Koha community maintains a library of user-contributed SQL reports that may be freely copied and modified by any Koha site at http://wiki.koha-community.org/wiki/SQL_Reports_Library.  

To obviate the need for much copying and pasting we have loaded the best of this library onto our Koha distribution site and offer you a Report Management Tool to allow you to browse and transfer any or all of these existing reports to your own Koha site.  This tool is available at the page http://test32admin.intersearch.com.au/manage_reports.php in the Koha staff client:

 

 

 

 

For a step by step explanation of how to use the Koha Report Management Tool please visit our detailed FAQ.