Chapitre 9. Reports

Table des matières

1. Custom Reports
1.1. Add Custom Report
1.2. Edit Custom Reports
2. Statistics Reports
2.1. Acquisitions Statistics
2.2. Patron Statistics
2.3. Catalog Statistics
2.4. Circulation Statistics
2.5. Serials Statistics
2.6. Patrons with the most checkouts
2.7. Most Circulated Items
2.8. Patrons with no checkouts
2.9. Items with no checkouts
2.10. Catalog by Item Type
2.11. Lost Items
2.12. Average Loan Time
3. Report Dictionary

1. Custom Reports

Koha's data is stored in a MySQL database which means that librarians can generate nearly any report they would like by either using the Guided Reports Wizard or writing their own SQL query.

1.1. Add Custom Report

1.1.1. Guided Report Wizard

The guided report wizard will walk you through a six step process to generate a report.

Step 1: Choose the module you want to report on. This will determine what tables and fields are available for you to query.

Step 2: Choose a report type. For now, Tabular is the only option available.

Step 3: Choose the fields you want in your report. You can select multiple fields and add them all at once by using CTRL+Click on each item you want to add before clicking the Add button.

Step 4: Choose any limits you might want to apply to your report (such as item types or branches). If you don't want to apply any limits, simply click Next instead of making an option.

Step 5: Perform math functions. If you don't want to do any calculations, simply click Next instead of making an option.

Step 6: Choose data order. If you want the data to print out in the order it's found in the database, simply click Finish.

When you are finished you will be presented with the SQL generated by the report wizard. From here you can choose to save the report by clicking 'Save' or copy the SQL and make edits to it by hand.

If you choose to save the report you will be asked to name your report and enter any notes regarding it.

Once your report is saved it will appear on the 'Use Saved' page with all other saved reports.

From here you can make edits, run the report, or schedule a time to have the report run.

1.1.2. Report from SQL

In addition to the report wizard, you have the option to write your own queries using SQL. To find reports written by other Koha users, visit the Koha Wiki: http://wiki.koha.org/doku.php?id=sql_library. You can also find your database structure in /installer/data/mysql/kohastructure.sql or online at: http://git.koha-community.org/cgi-bin/gitweb.cgi?p=koha.git;a=blob_plain;f=installer/data/mysql/kohastructure.sql;hb=HEAD.

To add your query, simply fill in the form presented

1.2. Edit Custom Reports

Every report can be edited from the reports lists. To see the list of reports already stored in Koha, click 'Use Saved.'

From this list you can edit any custom report by clicking 'Edit SQL'