Protected: Guide to Reports on Koha By BASE Library on 16th August 2016 in BASE Library Staff Guides Intro This content is password protected. To view it please enter your password below: Password: ContentsIntroThe statistics wizardStatistics wizard example 1Statistics wizard example 2One-click circulation reportsOther simple circulation and patron reportsGuided reportsIntroduction to SQL and the Koha databaseSimple SQL statementsCreating a new SQL report on KohaMore SQL statementsCreating a new SQL report on Koha - Example 2Finding and re-running an SQL report saved on KohaJoining tablesMore complex example of joining tablesNaming columns – ‘AS’ commandHTML links in report results‘Runtime values’ – questions to answer when running the reportReport templates (saved reports)Koha Reports LibraryOther useful informationContinue: The statistics wizard Related
