@@ -, +, @@ --- .../en/modules/help/reports/acquisitions_stats.tt | 2 +- .../prog/en/modules/help/reports/bor_issues_top.tt | 2 +- .../prog/en/modules/help/reports/borrowers_out.tt | 2 +- .../en/modules/help/reports/borrowers_stats.tt | 2 +- .../prog/en/modules/help/reports/cat_issues_top.tt | 2 +- .../prog/en/modules/help/reports/catalogue_out.tt | 2 +- .../en/modules/help/reports/catalogue_stats.tt | 2 +- .../prog/en/modules/help/reports/dictionary.tt | 2 +- .../prog/en/modules/help/reports/guided_reports.tt | 63 +++++++++----------- .../en/modules/help/reports/issues_avg_stats.tt | 2 +- .../prog/en/modules/help/reports/issues_stats.tt | 2 +- .../prog/en/modules/help/reports/itemslost.tt | 2 +- .../prog/en/modules/help/reports/manager.tt | 2 +- .../prog/en/modules/help/reports/reports-home.tt | 2 +- .../prog/en/modules/help/reports/reserves_stats.tt | 2 +- .../prog/en/modules/help/reports/serials_stats.tt | 2 +- 16 files changed, 44 insertions(+), 49 deletions(-) --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/acquisitions_stats.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/acquisitions_stats.tt @@ -12,6 +12,6 @@

Choosing amount will change your results to appear as the sum of the amounts spent.

-

See the full documentation for Acquisitions Statistics in the manual (online).

+

See the full documentation for Acquisitions Statistics in the manual (online).

[% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/bor_issues_top.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/bor_issues_top.tt @@ -8,6 +8,6 @@

You can also choose to export to a file that you can manipulate to your needs.

-

See the full documentation for the Patrons with the most Checkouts report in the manual (online).

+

See the full documentation for the Patrons with the most Checkouts report in the manual (online).

[% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_out.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_out.tt @@ -8,6 +8,6 @@

You can also choose to export to a file that you can manipulate to your needs.

-

See the full documentation for the Patrons with no Checkouts report in the manual (online).

+

See the full documentation for the Patrons with no Checkouts report in the manual (online).

[% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_stats.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_stats.tt @@ -8,7 +8,7 @@

Based on your selections, you may see some query information above your results table. You can also choose to export to a file that you can manipulate to your needs.

-

See the full documentation for Patron Statistics in the manual (online).

+

See the full documentation for Patron Statistics in the manual (online).

[% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/cat_issues_top.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/cat_issues_top.tt @@ -8,6 +8,6 @@

You can also choose to export to a file that you can manipulate to your needs.

-

See the full documentation for the Most Circulation Items report in the manual (online).

+

See the full documentation for the Most Circulation Items report in the manual (online).

[% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_out.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_out.tt @@ -8,6 +8,6 @@

You can also choose to export to a file that you can manipulate to your needs.

-

See the full documentation for the Items with no Checkouts report in the manual (online).

+

See the full documentation for the Items with no Checkouts report in the manual (online).

[% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_stats.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_stats.tt @@ -8,7 +8,7 @@

You can also choose to export to a file that you can manipulate to your needs.

-

See the full documentation for Catalog Statistics in the manual (online).

+

See the full documentation for Catalog Statistics in the manual (online).

[% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/dictionary.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/dictionary.tt @@ -18,6 +18,6 @@

Then when generating reports on the module you created the value for you will see an option to limit by the definition at the bottom of the usual filters.

-

See the full documentation for the Reports Dictionary in the manual (online).

+

See the full documentation for the Reports Dictionary in the manual (online).

[% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tt @@ -38,7 +38,7 @@ -

Edit Reports

+

Edit Reports

Custom reports can be edited in their entirety from the Saved Guided Reports page.

@@ -51,52 +51,47 @@

Report from SQL

-

In addition to the report wizard, you have the option to write your own queries using SQL. To find reports written by other Koha users, visit the Koha Wiki: http://wiki.koha-community.org/wiki/SQL_Reports_Library. You can also find your database structure in /installer/data/mysql/kohastructure.sql or online at: http://schema.koha-community.org.

+

In addition to the report wizard, you have the option to write your own queries using SQL. To find reports written by other Koha users, visit the Koha Wiki: http://wiki.koha-community.org/wiki/SQL_Reports_Library. You can also find your database structure in /installer/data/mysql/kohastructure.sql or online at: http://schema.koha-community.org.

To add your query, click the link to 'Create from SQL' on the main reports module or the New button at the top of the Saved Reports page.

Fill in the form presented

-

Once everything is entered click the 'Save Report' button and you'll be presented with options to run it. Once a report is saved you do not have to recreate it you can simply find it on the Saved Reports page and run or edit it.

- -

Questions

+

Note: There is a limit of 10,000 records put on SQL statements entered in Koha. To get around this you want to add 'LIMIT 100000' to the end of your SQL statement (or any other number above 10,000.

-

What are duration and visibility?

-

The duration field may be visible or not, don't worry if you don't see it. If you see it, it says how long a report run is kept in Koha and, any subsequent re-run will in fact display the result run the 1st time

-

The visibility field specify if your report is accessible without authentication from the OPAC. Reports can be retrieved from the following URLs: -

-

(replace localhost and localhost:8080 with the appropriate URLs)

+

Once everything is entered click the 'Save Report' button and you'll be presented with options to run it. Once a report is saved you do not have to recreate it you can simply find it on the Saved Reports page and run or edit it.

Is there a repository for reports?

@@ -104,6 +99,6 @@

NEKLS also has a great page (http://www.nexpresslibrary.org/training/reports-training/) with a list of reports they have written.

-

See the full documentation for Custom Reports in the manual (online).

+

See the full documentation for Custom Reports in the manual (online).

[% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_avg_stats.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_avg_stats.tt @@ -8,6 +8,6 @@

You can also choose to export to a file that you can manipulate to your needs.

-

See the full documentation for the Average Loan Time report in the manual (online).

+

See the full documentation for the Average Loan Time report in the manual (online).

[% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_stats.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_stats.tt @@ -19,6 +19,6 @@
  • For a single day, an example would be: 11/15/2009 to 11/16/2009 to find what circulated on the 15th
  • -

    See the full documentation for Circulation Statistics in the manual (online).

    +

    See the full documentation for Circulation Statistics in the manual (online).

    [% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/itemslost.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/itemslost.tt @@ -16,6 +16,6 @@ -

    See the full documentation for the Lost Items report in the manual (online).

    +

    See the full documentation for the Lost Items report in the manual (online).

    [% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/manager.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/manager.tt @@ -8,6 +8,6 @@

    You can also choose to export to a file that you can manipulate to your needs.

    -

    See the full documentation for the Catalog by Item Type report in the manual (online).

    +

    See the full documentation for the Catalog by Item Type report in the manual (online).

    [% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/reports-home.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/reports-home.tt @@ -19,6 +19,6 @@ -

    See the full documentation for Reports in the manual (online).

    +

    See the full documentation for Reports in the manual (online).

    [% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/reserves_stats.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/reserves_stats.tt @@ -10,6 +10,6 @@

    You can also choose to export to a file that you can manipulate to your needs.

    -

    See the full documentation for Holds Statistics in the manual (online).

    +

    See the full documentation for Holds Statistics in the manual (online).

    [% INCLUDE 'help-bottom.inc' %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/serials_stats.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/serials_stats.tt @@ -8,6 +8,6 @@

    You can also choose to export to a file that you can manipulate to your needs.

    -

    See the full documentation for Serials Statistics in the manual (online).

    +

    See the full documentation for Serials Statistics in the manual (online).

    [% INCLUDE 'help-bottom.inc' %] --