[% USE raw %]
[% USE Asset %]
[% USE KohaDates %]
[% USE Koha %]
[% USE ColumnsSettings %]
[% USE JSON.Escape %]
[% SET footerjs = 1 %]
[%- BLOCK area_name -%]
[%- SWITCH area -%]
[%- CASE 'CIRC' -%]Circulation
[%- CASE 'CAT' -%]Catalog
[%- CASE 'PAT' -%]Patrons
[%- CASE 'ACQ' -%]Acquisitions
[%- CASE 'ACC' -%]Accounts
[%- CASE 'SER' -%]Serials
[%- END -%]
[%- END -%]
[% INCLUDE 'doc-head-open.inc' %]
Koha › Reports › Guided reports wizard
[%- IF ( saved1 ) -%]
› Saved reports
[%- ELSIF ( create ) -%]
› Create from SQL
[%- ELSIF ( showsql ) -%]
› Saved reports › SQL view
[%- ELSIF ( execute ) -%]
› Saved reports › [% name | html %] Report
[%- ELSIF ( editsql ) -%]
› Saved reports › Edit SQL report
[%- END -%]
[%- IF ( build1 ) -%]
› Build a report, step 1 of 6: Choose a module
[%- ELSIF ( build2 ) -%]
› Build a report, step 2 of 6: Pick a report type
[%- ELSIF ( build3 ) -%]
› Build a report, step 3 of 6: Select columns for display
[%- ELSIF ( build4 ) -%]
› Build a report, step 4 of 6: Select criteria to limit on
[%- ELSIF ( build5 ) -%]
› Build a report, step 5 of 6: Pick which columns to total
[%- ELSIF ( build6 ) -%]
› Build a report, step 6 of 6: Select how you want the report ordered
[%- END -%]
[% INCLUDE 'doc-head-close.inc' %]
[% Asset.css("lib/codemirror/codemirror.min.css") | $raw %]
[% Asset.css("css/reports.css") | $raw %]
[% Asset.css("lib/d3c3/c3.min.css") | $raw %]
[% INCLUDE 'header.inc' %]
[% INCLUDE 'circ-search.inc' %]
Home
› Reports
› Guided reports wizard
[% IF ( saved1 ) %]
› Saved reports
[% ELSIF ( create ) %]
› Create from SQL
[% ELSIF ( showsql ) %]
› Saved reports › SQL view
[% ELSIF ( editsql ) %]
› Saved reports › Edit SQL report
[% ELSIF ( execute ) %]
› Saved reports › [% name | html %] Report
[% ELSIF ( build1 || build2 || build3 || build4 || build5 || build6 ) %]
› Build a report
[% IF ( build1 ) %]
› Step 1 of 6: Choose a module
[% ELSIF ( build2 ) %]
› Step 2 of 6: Pick a report type
[% ELSIF ( build3 ) %]
› Step 3 of 6: Select columns for display
[% ELSIF ( build4 ) %]
› Step 4 of 6: Select criteria to limit on
[% ELSIF ( build5 ) %]
› Step 5 of 6: Pick which columns to total
[% ELSIF ( build6 ) %]
› Step 6 of 6: Select how you want the report ordered
[% END %]
[% END %]
Update SQL
Loading
[% INCLUDE "reports-toolbar.inc" %]
[% IF ( start ) %]
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
[% IF ( CAN_user_reports_create_reports ) %]
[% END %]
[% IF ( CAN_user_reports_execute_reports ) %]
[% END %]
[% IF ( CAN_user_reports_create_reports ) %]
[% END %]
Reports Dictionary
Use the reports dictionary to define custom criteria to use in your reports
[% END # /IF (start) %]
[% IF report_converted %]
The report "[% report_converted | html %]" has been converted.
[% END %]
[% IF report_converted %]
The report "[% report_converted | html %]" has been converted.
[% END %]
[% IF ( saved1 ) %]
[% IF ( savedreports ) %]
Saved reports
[% IF ( filters.date || filters.author || filters.keyword ) %]
Filtered by:
[% IF ( filters.date ) %]
Date: [% filters.date | html %]
[% END %]
[% IF ( filters.author ) %]
Author: [% filters.author | html %]
[% END %]
[% IF ( filters.keyword ) %]
Keyword: [% filters.keyword | html %]
[% END %]
Clear
[% IF (Koha.Preference('Mana') == 1) %]
[% IF manamsg %]
[% manamsg | html %]
[% END %]
[% END %]
[% ELSE # IF ( savedreports ) %]
[% IF (filter_set || filters.date || filters.author || filters.keyword) %]
No saved reports match your criteria.
[% IF ( CAN_user_reports_create_reports ) %]
[% END %]
[% ELSE %]
There are no saved reports.
[% IF ( CAN_user_reports_create_reports ) %]
Build a new report?
[% END %]
[% END # IF (filter_set || filters.date || filters.author || filters.keyword) %]
[% END # /IF ( savedreports ) %]
[% END # /IF ( saved1 ) %]
[% INCLUDE 'mana/mana-share-report.inc' %]
[% IF ( build1 ) %]
[% IF ( cache_error) %]
Please choose a cache_expiry less than 30 days
[% END %]
Build a report
[% END # /build1 %]
[% IF ( build2 ) %]
Build a report
[% END # /IF (build2 ) %]
[% IF ( build3 ) %]
Build a report
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.
[% END # /IF ( build3 ) %]
[% IF ( build4 ) %]
Build a report
[% END # /IF ( build4 ) %]
[% IF ( build5 ) %]
Build a report
Step 5 of 6: Pick which columns to total
[% END # /IF ( build5 ) %]
[% IF ( build6 ) %]
Build a report
Step 6 of 6: Choose how you want the report ordered
[% END #/ IF ( build6 ) %]
[% IF ( showreport ) %]
Confirm custom report
Your report will be generated with the following SQL statement.
[% sql | html %]
[% END #/ IF ( showreport ) %]
[% IF ( save ) %]
[% END # /IF( save ) %]
[% IF ( warn_authval_problem ) %]
Errors found when processing parameters for report: [% name | html %]
[% FOREACH problematic_authval IN problematic_authvals %]
[% problematic_authval.name | html %]: The authorized value category ([% problematic_authval.authval | html %])
you selected does not exist.
[% END %]
[% END # /IF ( warn_authval_problem )%]
[% IF ( enter_params ) %]
[% END # /IF ( enter_params ) %]
[% IF ( execute ) %]
[% name | html %]
[% IF ( notes ) %]
Notes: [% notes | html %]
[% END %]
[% IF ( unlimited_total ) %]
Total number of results:
[% unlimited_total | html %]
[% IF unlimited_total > limit %]
([% limit | html %] shown)
[% END %].