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 report_converted %] [% END %] [% IF report_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 ) %] [% END %] [% IF ( filters.keyword ) %] Keyword: [% filters.keyword | html %] [% END %] Clear
[% END %]- All [% FOREACH group IN groups_with_subgroups %]
- [% group.name | html %] [% END %]
Build a report
[% END %] [% IF ( build2 ) %]Build a report
[% END %] [% 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 ( build4 ) %]Build a report
[% END %] [% IF ( build5 ) %]Build a report
Step 5 of 6: Pick which columns to total
[% END %] [% IF ( build6 ) %]Build a report
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 ( 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 %]
[% IF ( notes ) %]Notes: [% notes | html %]
[% END %] [% IF ( unlimited_total ) %]Total number of results: [% unlimited_total | html %][% IF unlimited_total > limit %] ([% limit | html %] shown)[% END %].
[% END %]Saved report results
[% name | html %]
[% notes | html %]
[% col | html %] | [% END %]