Skip to content

<img fetchpriority="high" width="1139" height="1122" src="https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText.png" class="custom-logo" alt="Health Libraries Midlands" decoding="async" srcset="https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText.png 1139w, https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText-300x296.png 300w, https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText-1024x1009.png 1024w, https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText-768x757.png 768w, https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText-1096x1080.png 1096w" sizes="(max-width: 1139px) 100vw, 1139px" />

Member Log In
Locations
Membership
FAQs
Forgotten Password?

<img fetchpriority="high" width="1139" height="1122" src="https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText.png" class="custom-logo" alt="Health Libraries Midlands" decoding="async" srcset="https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText.png 1139w, https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText-300x296.png 300w, https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText-1024x1009.png 1024w, https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText-768x757.png 768w, https://www.healthlibrariesmidlands.nhs.uk/wp-content/uploads/2022/03/cropped-LogoHeLM_WhiteText-1096x1080.png 1096w" sizes="(max-width: 1139px) 100vw, 1139px" />

Member Log In
Locations
Membership
FAQs
Forgotten Password?

Guide to Reports 5. Report templates (saved reports) and the Reports Library

Introduction to SQL and the Koha database

Contents

1. Intro
2. The statistics wizard
3. Statistics wizard example 1
4. Statistics wizard example 2
5. One-click circulation reports
6. Other simple circulation and patron reports
7. Guided reports
8. Introduction to SQL and the Koha database
9. Simple SQL statements
10. Creating a new SQL report on Koha
11. More SQL statements
12. Creating a new SQL report on Koha - Example 2
13. Finding and re-running an SQL report saved on Koha
14. Joining tables
15. More complex example of joining tables
16. Naming columns – ‘AS’ command
17. HTML links in report results
18. ‘Runtime values’ – questions to answer when running the report
19. Report templates (saved reports)
20. Koha Reports Library
21. Other useful information

This content is password protected. To view it please enter your password below:

Password:

© 2024 Health Libraries Midlands. Built using WordPress and the Mesmerize theme

Skip to content

Accessibility Tools

Increase Text
Decrease Text
Grayscale
High Contrast
Negative Contrast
Light Background
Links Underline
Readable Font
Reset