Guided Reports

Use the guided reports engine to create non standard reports. This feature aims to provide some middle ground between the built in canned reports and writing custom SQL reports.

Build And Run Reports

Reports Dictionary

Use the reports dictionary to define custom criteria to use in your reports

Saved Reports

Choose the report to run from the list

Report NameTypeNotesSaved ResultsSaved SQL 
"> &phase=Show%20SQL">Show SQL   &phase=Edit%20SQL">Edit SQL &phase=Run%20this%20report">Run ">Schedule &phase=Delete%20Saved">Delete

There are no saved reports. Build new?

Build A Report

Step 1 of 6: Choose a Module to Report on

Build A Report

" />
Step 2 of 6: Pick a Report Type

Step 3 of 6: Select Columns for Display

Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.

" /> " />

" /> " /> " />
Step 4 of 6: Select Criteria to Limit on
" value="" /> _value" name="_value" value="" />/lib/calendar/cal.gif" id="buttonfrom" style="cursor: pointer;" alt="Show Calendar" title="Show Calendar" />
Dictionary Definitions
" />

Step 5 of 6: Pick which columns to total

" /> " /> " /> " /> " />
" value="" />

Step 6 of 6: Choose how you want the report ordered

" /> " /> " /> " /> " /> " />
" name="order_by" value="" />

Confirm Custom Report

Your report will be generated with the following SQL statement.

" /> " />

You will need to save the report before you can execute it

" /> " />
Save Your Custom Report

Total number of rows matching the (unlimited) query is .

" />
Create Report From SQL
  1. value="" />
Master:   Sub report:

Saved Report Results

"/>
Edit SQL
  1. " />

Your report has been saved

The report you have created has now been saved. You can now

The following error was encountered:
This report contains the SQL keyword .
Use of this keyword is not allowed in Koha reports due to security and data integrity risks. Only SELECT queries are allowed.
Please return to the "Saved Reports" screen and delete this report or retry creating a new one. The database returned the following error:

Please check the log for further details.