Reports
How to include ALL as an option for a report dropdown
It is possible to include an ALL option in a report dropdown so that staff have the choice of either running the report separately for each individual entry in the authorised value or running the report for every single entry in the authorised value ...
How to create a report group
The video attached below walk through the process of creating a report group. Version Date Detail Author 1.0 01/02/21 Document created and video attached Holly Cooper 1.2 16/04/21 Completing doc. Holly Cooper 1.3 18/02/22 Experimenting with video ...
How to recover information about a deleted report
It is possible to set up the system to record information about actions taken in different modules so they can be viewed later. This document is intended to outline how to set up the system to log details about deleted reports. This log will ...
How to Find and Run a SQL Report
What are reports for? Reports are used to find and present data about the information on the system in a structured manner. This information is drawn from tables storing all information about the system which can be found here: ...
How to Report on Star Ratings
If star rating are enabled on the OPAC, staff members may wish to view details about how the feature is being used. This document will provide a basic SQL report which can be used to identify star ratings on the site. Step 1 - Navigate to the report ...
How to schedule an SQL report
It is possible to set a report to run at a set time and date and have the results sent as an email. Step 1 - Defining the schedule To schedule a report, go to Reports > Guided Reports > Use saved and find the report you want to schedule. Go to the ...
Using the Statistics Wizard
Using the Statistics Wizard Koha provides a wizard to allow staff to generate statistics using their own criteria. For the example of circulation transactions staff can specify the time period to query and how the results will be reported. The ...
SQL Report Request Form
To allow the support desk help you create SQL reports, please use please use the following form when requesting a SQL report. A downloadable form is available as an attachment at the bottom of this page. Log a ticket on the support ...
Overview of some SQL Report Functions
Overview of SQL Report Functions This FAQ is an example of a simple report describing the “anatomy” of the SQL code used. Details about the different functions are outlined in the table below the report. Some functions are mandatory to use in order ...