Protected: Guide to Reports on Koha

Intro

• 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