How to view the content of an SQL report

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 the Koha home page and click on it.


This will take you to a new page. Under Guided reports click Use saved and you will be brought to a new page with a table of all the reports currently on your system.

This will take you to a new page with a table of reports already saved on your site

At the top of this table there is a search box. Search for the title or number of the report, or for a keyword. This will narrow the list of reports to ones related to the search.


How to view the content of a report

Once you have found the report you want to run, go to the right hand side of the row the report is on and click the arrow beside the Run button. This will create a dropdown menu of options. 


Click the View option on the dropdown menu.
This will open a page where the content of the report will be static and uneditable.

How to view the content of a report with the option to interact with it

It is also possible to view the report and interact with the SQL content. In the dropdown menu, click Edit.
This will show the content of the SQL report and it will be possible to make changes to it.


If you make any changes to the report, they can be saved by clicking the Update SQL button.

If you are only viewing the content through the Edit tool but don't want to make any changes, just use the breadcrumbs at the top of the page to move to a different page.


VersionDateDetailAuthor
1.023/04/26Document created
T
Holly Cooper



























    • Related Articles

    • 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 ...

    • 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 ...

    • 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 ...

    • 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 ...

    • 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 ...