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 %] Report
[% ELSIF ( buildx ) %]› Build A Report, Step [% buildx %] of 6:
[% IF ( build1 ) %]Choose a Module
[% ELSIF ( build2 ) %]Pick a Report Type
[% ELSIF ( build3 ) %]Select Columns for Display
[% ELSIF ( build4 ) %]Select Criteria to Limit on
[% ELSIF ( build5 ) %]Pick which columns to total
[% ELSIF ( build6 ) %]Select how you want the report ordered
[% END %]
[% END %]
[% INCLUDE 'doc-head-close.inc' %]
[% INCLUDE 'calendar.inc' %]
[% 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 ( execute ) %]Saved Reports › [% name %] Report
[% ELSIF ( buildx ) %]Build A Report › Step [% buildx %] of 6:
[% IF ( build1 ) %]Choose a Module
[% ELSIF ( build2 ) %]Pick a Report Type
[% ELSIF ( build3 ) %]Select Columns for Display
[% ELSIF ( build4 ) %]Select Criteria to Limit on
[% ELSIF ( build5 ) %]Pick which columns to total
[% ELSIF ( build6 ) %]Select how you want the report ordered
[% END %]
[% END %]
[% 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 ( saved1 ) %]
[% IF ( savedreports ) %]
[% 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 %]
[% END %]
[% END %]
[% IF ( build1 ) %]
Build A Report
[% END %]
[% IF ( build2 ) %]
Build A Report
[% END %]
[% IF ( build3 ) %]
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 ( build4 ) %]
[% END %]
[% IF ( build5 ) %]
Step 5 of 6: Pick which columns to total
[% END %]
[% IF ( build6 ) %]
Step 6 of 6: Choose how you want the report ordered
[% END %]
[% IF ( showreport ) %]
Confirm Custom Report
Your report will be generated with the following SQL statement.
[% sql |html %]
[% END %]
[% IF ( save ) %]
[% END %]
[% IF ( enter_params ) %]
[% END %]
[% IF ( execute ) %]
[% name %]
[% IF ( notes ) %]
[% notes %]
[% END %]
[% IF ( unlimited_total ) %]
Total number of rows matching the (unlimited) query is [% unlimited_total %].
[% END %]
[% sql %]
[% pagination_bar %]
[% UNLESS ( errors ) %]
[% FOREACH header_ro IN header_row %]
[% header_ro.cell %]
[% END %]
[% FOREACH result IN results %]
[% FOREACH cell IN result.cells %]
[% cell.cell %]
[% END %]
[% END %]
[% END %]
[% END %]
[% IF ( create ) %]
[% END %]
[% IF ( compound ) %]
[% END %]
[% IF ( save_compound ) %]
[% master %]
[% subsql %]
[% END %]
[% IF ( retresults ) %]
Saved Report Results
[% name %]
[% notes %]
[% FOREACH result IN results %]
[% result.row %]
[% END %]
[% END %]
[% IF ( showsql ) %]
[% END %]
[% IF ( editsql ) %]
[% END %]
[% IF ( save_successful ) %]
[% UNLESS ( errors ) %]
Your report has been saved
The report you have created has now been saved. You can now