- A public report is accessible via a URL that looks like this:
http://MYOPAC/cgi-bin/koha/svc/report?id=REPORTID
-Chose Module for Report
|image881|
**Note**
Step 2: Choose a report type. For now, Tabular is the only option
available.
-Report Type
|image882|
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.
-Select database fields to query
|image883|
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.
-Choose limits
|image884|
Step 5: Perform math functions. If you don't want to do any
calculations, simply click Next instead of making an option.
-Choose math functions
|image885|
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.
-Choose ordering
|image886|
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.
-Custom Report Confirmation
|image887|
If you choose to save the report you will be asked to name your report,
sort it in to groups and subgroups and enter any notes regarding it.
-Save custom report
|image888|
Once your report is saved it will appear on the 'Use Saved' page with
all other saved reports.
-Saved Reports list
|image889|
From here you can make edits, run the report, or schedule a time to have
reports module or the 'New report' button at the top of the 'Saved
reports' page.
-New SQL Report
|image890|
Fill in the form presented
-Create Report from SQL
|image891|
- The 'Name' is what will appear on the Saved Reports page to help you
The Description (OPAC) field needs to contain the authorised value for
the Report Group that the Subgroup falls under.
- Report subgroup
|image892|
- **Note**
running a report you can use the 'date' keyword like this:
<<Enter Date\|date>>
- Date Picker
|image893|
**Note**
branch pull down would be generated like this
<<Branch\|branches>>
- Branch pull down
|image894|
**Note**
'Saved reports' page to see all of the reports listed on your system
already.
-Saved Reports
|image895|
To the right of every report there is an 'Actions' pull down. Clicking
Every report can be edited from the reports lists. To see the list of
reports already stored in Koha, click 'Use Saved.'
-Saved Reports
|image896|
To find the report you'd like to edit you can sort by any of the columns
From this list you can edit any custom report by clicking 'Actions' to
the right of the report and choosing 'Edit' from the menu that appears.
-Edit Report Option
|image897|
The form to edit the report will appear.
-Edit SQL Form
|image898|
.. _running-custom-reports-label:
Saved Reports page and clicking the 'Actions' button to the right of the
report and choosing 'Run'.
-Run Report
|image899|
When you report runs you will either be asked for some values
-Enter report parameters
|image900|
or you will see the results right away
-Report results
|image901|
From the results you can choose to rerun the report by clicking 'Run
Using the form provided, choose which value you would like to appear in
the Column and which will appear in the Row.
-Acquisitions Statistics
|image902|
If you choose to output to the browser your results will print to the
screen.
-Acquisitions Statistics Results
|image903|
You can also choose to export to a file that you can manipulate to your
When generating your report, note that you get to choose between
counting or summing the values.
-Acquisitions Stats Options
|image904|
Choosing amount will change your results to appear as the sum of the
amounts spent.
-Acquisitions statistics with totals
|image905|
.. _patron-statistics-label:
Using the form provided, choose which value you would like to appear in
the Column and which will appear in the Row.
-Patron Statistics Options
|image906|
If you choose to output to the browser your results will print to the
screen.
-Patron Statistics Results
|image907|
Based on your selections, you may see some query information above your
Using the form provided, choose which value you would like to appear in
the Column and which will appear in the Row.
-Catalog Statistics Form
|image908|
If you choose to output to the browser your results will print to the
screen.
-Catalog Statistic Results
|image909|
You can also choose to export to a file that you can manipulate to your
Using the form provided, choose which value you would like to appear in
the Column and which will appear in the Row.
-Circulation Statistics
|image910|
If you choose to output to the browser your results will print to the
screen.
-Circulation Statistic Results
|image911|
You can also choose to export to a file that you can manipulate to your
in house usage of items simply by choosing 'Local Use' from the 'Type'
pull down:
-In House Use Stats
|image912|
.. _serials-statistics-label:
Using the form provided, choose how you would like to list the serials
in your system.
-Serials Statistics
|image913|
If you choose to output to the browser your results will print to the
screen.
-Serials Results
|image914|
You can also choose to export to a file that you can manipulate to your
want to display in the column and what value to show in the row. You can
also choose from the filters on the far right of the form.
-Hold Statistics Form
|image915|
If you choose to output to the browser your results will print to the
screen.
-Hold Stats Results
|image916|
You can also choose to export to a file that you can manipulate to your
This report will simply list the patrons who have the most checkouts.
-Patrons with the most checkouts form
|image917|
If you choose to output to the browser your results will print to the
screen.
-Top checkouts results
|image918|
You can also choose to export to a file that you can manipulate to your
This report will simply list the items that have the been checked out
the most.
-Most Circulation Items Form
|image919|
If you choose to output to the browser your results will print to the
screen.
-Top Circulation Items Results
|image920|
You can also choose to export to a file that you can manipulate to your
This report will list for you the patrons in your system who haven't
checked any items out.
-Patrons with no Checkouts
|image921|
If you choose to output to the browser your results will print to the
screen.
-Results for Patrons with no Checkouts
|image922|
You can also choose to export to a file that you can manipulate to your
This report will list items in your collection that have never been
checked out.
-Items with No Checkouts
|image923|
If you choose to output to the browser your results will print to the
screen.
-Items with no checkouts results
|image924|
You can also choose to export to a file that you can manipulate to your
This report will list the total number of items of each item type per
branch.
-Catalog by Item Type
|image925|
If you choose to output to the browser your results will print to the
screen.
-Total of Items by Type and Branch
|image926|
You can also choose to export to a file that you can manipulate to your
This report will allow you to generate a list of items that have been
marked as Lost within the system
-Lost Items Report
|image927|
.. _average-loan-time-label:
This report will list the average time items are out on loan based on
the criteria you enter:
-Average Checkout Period Form
|image928|
If you choose to output to the browser your results will print to the
screen.
-Average Checkout Period Results
|image929|
You can also choose to export to a file that you can manipulate to your
Step 1: Name the definition and provide a description if necessary
-Create a Definition
|image930|
Step 2: Choose the module that the will be queried.
-Select Koha Module
|image931|
Step 3: Choose columns to query from the tables presented.
-Choose columns
|image932|
Step 4: Choose the value(s) from the field(s). These will be
automatically populated with options available in your database.
-Choose fields and values
|image933|
Confirm your selections to save the definition.
-Confirm Definition
|image934|
Your definitions will all appear on the Reports Dictionary page
-Reports Dictionary Listing
|image935|
Then when generating reports on the module you created the value for you
will see an option to limit by the definition at the bottom of the usual
filters.
-Dictionary Limit Option
|image936|