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.
| Version | Date | Detail | Author |
| 1.0 | 23/04/26 | Document created T | Holly Cooper |