reports tutorial


Printing Lists the “Old Way” in Koha 3.14 1

I’ve been teaching our partners all about Koha 3.14 and one of the great upgrades that comes with 3.14 is a new interface for lists in the staff client. I happen to love this new look and feel, but a few of our partners noted that the new printable version […]


Reports Permission in Koha 3

A short while ago we got the following anonymous message via our contact form on the ByWater website: By allowing people to block which staff members are allowed to write reports you are limiting the customer service of your product. Please discuss this with anybody you sell your product to […]


What’s new in Reports in Koha 3.10

Coming in Koha 3.10 are some new ways to manage your reports. To learn about how to add reports please use the tutorials written and recorded in the past. Learn more about this in the manual as well. If you have an idea for a tutorial video I should do […]


LEFT JOIN….RIGHT JOIN…..INNER JOIN? What join do I use? 2

Koha offers its users a very strong reporting tool. In reports you can quite easily create your own SQL queries to pull your own data out of Koha. If you’ve taken advantage of the Koha Reports Library you’ve probably run across some fairly complex jargon in some of the SQL […]


Runtime Parameters in Koha 3.6 Reports 2

Reports in Koha are powerful – but runtime parameters make them even more so. This video will show you how to use runtime parameters in Koha reports to force reports to ask you for values before it runs. As always, if you have an idea for a video, please just […]


Koha Reporting Help

In my role as documentation manager I have been adding comments to the MySQL structure for Koha to help report writers figure out which fields contain what data. You can see some comments by scrolling through the database structure and looking for the bits that start with a double dash […]


Tracking in house use in Koha 3.4

Last week I showed you how to create a patron type for your statistical patrons. This week I’ll show you how to use that patron type to create a patron for tracking in house use. As always, if you have an idea for a video, please just let me know […]


Creating a Statistical Patron in Koha 3.4 1

Koha has the ability to track the use of items in the library by logging those items as ‘checked out’ to a statistical (or fake) patron. This video will walk you through setting up a category for this patron type and next week we’ll cover tracking in house use of […]