[% INCLUDE 'doc-head-open.inc' %]
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.
Use the reports dictionary to define custom criteria to use in your reports
[% END %] [% IF ( saved1 ) %] [% IF ( savedreports ) %]ID | Report name | Type | Area | Group | Subgroup | Notes | Author | Creation date | Public | [% IF (usecache) %]Cache expiry (seconds) | [% END %]Saved results | Saved SQL | |||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
[% savedreport.id %] | [% savedreport.report_name %] | [% savedreport.type %] | [% savedreport.areaname %] | [% savedreport.groupname %] | [% savedreport.subgroupname %] | [% savedreport.notes %] | [% savedreport.borrowersurname %][% IF ( savedreport.borrowerfirstname ) %], [% savedreport.borrowerfirstname %][% END %] ([% savedreport.borrowernumber %]) | [% savedreport.date_created %] | [% IF (savedreport.public) %]Yes | [% ELSE %]No | [% END %] [% IF (usecache) %][% savedreport.cache_expiry %] | [% END %][% IF ( savedreport.date_run ) %][% savedreport.date_run %][% END %] | Show [% IF ( CAN_user_reports_create_reports ) %] Edit [% END %] | Run Schedule | [% IF ( CAN_user_reports_create_reports ) %]Delete | [% END %]
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 ) %]Your report will be generated with the following SQL statement.
[% sql |html %]
[% END %] [% IF ( save ) %] [% END %] [% IF ( enter_params ) %] [% END %] [% IF ( execute ) %][% notes %]
[% END %] [% IF ( unlimited_total ) %]Total number of rows matching the (unlimited) query is [% unlimited_total %].
[% END %][% sql |html %]
[% header_ro.cell %] | [% END %]
---|
[% cell.cell %] | [% END %]
[% notes %]