Reports
Sixth Report Challenge: A client wants to add a custom label to on of the headings in the report results
These notes are intended to be used to help answer the associated Report Challenge that was released this week. Take a look at the question below and think about how you would approach answering it: A client wants to add a custom label to on of the ...
Fifth Report Challenge: A client wants to create a report which shows a count of items within a specific item type.
These notes are intended to be used to help answer the associated Report Challenge that was released this week. Take a look at the question below and think about how you would approach answering it: A client wants to create a report which shows a ...
Fourth Report Challenge: A client wants to put together a report to show cardnumber, firstname, second name, current issues
These notes are intended to be used to help answer the associated Report Challenge that was released this week. Take a look at the question below and think about how you would approach answering it: A client wants to put together a report to show ...
Third Report Challenge: A client wants to put together a report to show the cardnumber, first name and second name, limited by patron category.
These notes are intended to be used to help answer the associated Report Challenge that was released this week. Take a look at the question below and think about how you would approach answering it: A client wants to put together a report to show the ...
Second Report Challenge: A client wants to put together a report to show the cardnumber, first name and second name, concatenated.
These notes are intended to be used to help answer associated "Report Challenge" that was released earlier. Take a look at the question below and think about how you would approach answering it: A client wants to put together a report to show the ...
First Report Challenge: A client wants to put together a report to show the cardnumber, first name and second name of all patrons on the system.
These notes are intended to be used to help answer the associated Report Challenge that was released last week. Take a look at the question below and think about how you would approach answering it: A client wants to put together a report to show the ...
What is a clause in a SQL report?
In SQL a clause is a tool which allows specific parameters to be set on what results should be brought back in a SQL report. Examples of some of the clauses that can be used in SQL: CLAUSE WHAT DOES IT DO? WHERE A clause which filters results to ...
Table Time: Issues, old_issues and statistics
When creating reports for circulation information, it is important to identify the correct table from the database schema to pull the information from. There are three tables that can be used to report on check outs, but they contain different ...
How to add an alias to a field in an SQL report
This document will outline how to define a custom label for a field in an SQL report. Fields in SQL report results will default to the name of the field in the Koha database. However, it is possible to add a custom label that is of more use to the ...
How and why to use the LIMIT function in an SQL report
This document will outline how to use the LIMIT function in an SQL report to control the number of results a report returns. Why to use the LIMIT function? The limit function reduces the number of results that a report will bring back to a specified ...
How to view the content of an SQL report
This document will outline how to view the content of an SQL report on the Koha system. This may be a precursor to editing the report or just a way to start studying the format of reports How to find reports on your system Go to the Reports module on ...
How and why to access the Koha database schema
SQL reports in Koha can be intimidating. One of the key resources to learn how to more effectively create, edit and read the results of SQL reports within Koha is the database schema site. This site provides a map of the database which includes the ...
Printed list of all books CKO
Book Scheme - Reports If you would like to print a single sheet for each student to use as a checklist of all items allocated to them, then from the home screen click on the Reports button and then under Guided Reports select Use Saved. There are 2 ...
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 ...
Question of the Week - Using the CASE statement and formatting information to be included in a SQL report
This document will outline how a list of information can be formatted so it can be easily added to a SQL statement as well as a creative way we used the CASE statement to categorise the different system preferences being shown in an SQL report. The ...
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. Reports use SQL to ask questions of the Koha database. How to find reports on your system Go to the Reports module on the Koha ...
How to Report on Star Ratings on the OPAC
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. For information on how to enable ...
How to schedule an SQL report
This document will outline how to schedule a report to run at a set time and date and have the results sent as an email. Defining the schedule To schedule a report, go to Reports > Guided Reports > Use saved and identify the report to be scheduled. ...
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
How to submit an SQL report request The following are the steps of requesting a new SQL report to be created. 1. Log a ticket on the support portal to start the process. 2. Take a note of the ticket number. 3. Click the link below to be taken to an ...
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 ...