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 %] [% END %] [% IF report_converted %] [% END %] [% IF ( saved1 ) %]Saved reports
[% IF ( savedreports ) %] [% IF ( filters.date || filters.author || filters.keyword ) %]Filtered by: [% IF ( filters.date ) %] Date: [% filters.date | html %] [% END %] [% IF ( filters.author ) %] [% END %] [% IF ( filters.keyword ) %] Keyword: [% filters.keyword | html %] [% END %] Clear
[% END %] [% WRAPPER tabs id= "tabs" %] [% WRAPPER tabs_nav %] [% WRAPPER tab_item tabname= "reports" bt_active= 1 %] All [% END %] [% FOREACH group IN groups_with_subgroups %] [% WRAPPER tab_item tabname= group.id %] [% group.name | html %] [% END %] [% END %] [% END # /WRAPPER tabs_nav %] [% WRAPPER tab_panels %] [% WRAPPER tab_panel tabname="reports" bt_active= 1 %]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 %][% name | html %] Report ID: [% id | html %]
Notes: [% notes | html %]
[% END %] [% IF ( unlimited_total ) %]Total number of results: [% unlimited_total | html %] [% IF unlimited_total >= limit %] ([% results.size | html %] shown) [% END %]
[% END %][% header_ro.cell | html %] | [% ELSIF header_ro.has_biblionumbers && ( header_ro.cell == 'biblionumber' || header_types.item( header_ro.cell ) == 'biblionumber' ) %][% header_ro.cell | html %] | [% ELSIF header_ro.cell == 'cardnumber' || header_types.item( header_ro.cell ) == 'cardnumber' %][% header_ro.cell | html %] | [% ELSIF header_ro.cell == 'borrowernumber' || header_types.item( header_ro.cell ) == 'borrowernumber' %][% header_ro.cell | html %] | [% ELSE %][% header_ro.cell | html %] | [% END %] [% END %]
---|---|---|---|---|
[% cells.cell | $raw %] | [% ELSIF header_row.$place.cell == 'biblionumber' || header_types.item(header_row.$place.cell) == 'biblionumber' %][% cells.cell | $raw %] | [% ELSIF header_row.$place.cell == 'borrowernumber' || header_types.item(header_row.$place.cell) == 'borrowernumber' %][% cells.cell | $raw %] | [% ELSIF header_row.$place.cell == 'cardnumber' || header_types.item(header_row.$place.cell) == 'cardnumber' %][% cells.cell | $raw %] | [% ELSE %][% cells.cell | $raw %] | [% END %] [% END %]
Create from SQL
[% END #/IF ( create ) %] [% IF saved_results %]Saved report results
[% name | html %]
[% notes | html %]
[% col | html %] | [% END %]