@@ -, +, @@ --- .../en/modules/help/reports/acquisitions_stats.tt | 22 ++++--- .../prog/en/modules/help/reports/bor_issues_top.tt | 23 +++---- .../prog/en/modules/help/reports/borrowers_out.tt | 20 ++++--- .../en/modules/help/reports/borrowers_stats.tt | 30 ++------- .../prog/en/modules/help/reports/cat_issues_top.tt | 22 +++---- .../prog/en/modules/help/reports/catalogue_out.tt | 24 ++++---- .../en/modules/help/reports/catalogue_stats.tt | 27 ++------- .../prog/en/modules/help/reports/dictionary.tt | 61 +++---------------- .../prog/en/modules/help/reports/guided_reports.tt | 30 +++++++--- .../en/modules/help/reports/issues_avg_stats.tt | 17 +++--- .../prog/en/modules/help/reports/issues_stats.tt | 43 +++++++------- .../prog/en/modules/help/reports/itemslost.tt | 6 ++- .../prog/en/modules/help/reports/manager.tt | 17 +++--- .../prog/en/modules/help/reports/reports-home.tt | 26 ++++++--- .../prog/en/modules/help/reports/serials_stats.tt | 22 ++----- 15 files changed, 165 insertions(+), 225 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 @@ -2,12 +2,16 @@
IMPORTANT: The Acquisitions 'Wizard' is designed to be a simple statistical snapshot, In each wizard, you will choose a single category to represent 'row' and another to represent 'column'.
-Using the form provided, choose which value you would like to appear in the Column and which will appear in the Row.
+ +If you choose to output to the browser your results will print to the screen.
+ +You can also choose to export to a file that you can manipulate to your needs.
+ +When generating your report, note that you get to choose between counting or summing the values.
+ +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).
+ +[% 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 @@ -1,16 +1,13 @@ [% INCLUDE 'help-top.inc' %] -This guided report will show you which patrons have checked out the most items.
-This report will simply list the patrons who have the most checkouts.
+ +If you choose to output to the browser your results will print to the screen.
+ +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).
+ +[% 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 @@ -1,11 +1,13 @@ [% INCLUDE 'help-top.inc' %] -This guided report will give you a snapshot of which (OR HOW MANY?) items have not been checked out at all. You can limit these items by branch
-This report will list for you the patrons in your system who haven't checked any items out.
+ +If you choose to output to the browser your results will print to the screen.
+ +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).
+ +[% 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 @@ -2,29 +2,13 @@IMPORTANT: The Patron 'Wizard' is designed to be a simple statistical snapshot, In each wizard, you will choose a single category to represent 'row' and another to represent 'column'.
-Using the form provided, choose which value you would like to appear in the Column and which will appear in the Row.
+ +If you choose to output to the browser your results will print to the screen.
+ +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).
[% 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 @@ -1,17 +1,13 @@ [% INCLUDE 'help-top.inc' %] -This guided report will show you which patrons
+This report will simply list the items that have the been checked out the most.
-If you choose to output to the browser your results will print to the screen.
+ +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).
+ +[% 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 @@ -1,15 +1,13 @@ [% INCLUDE 'help-top.inc' %] -This guided report will give you a snapshot of items have not been checked out at all. You can limit these items by branch
- -This report will list items in your collection that have never been checked out.
+ +If you choose to output to the browser your results will print to the screen.
+ +You can also choose to export to a file that you can manipulate to your needs.
+ +See the full documentation for the Issues 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 @@ -1,27 +1,14 @@ [% INCLUDE 'help-top.inc' %] -IMPORTANT: The Catalog 'Wizard' is designed to be a simple statistical snapshot. You will choose a single category to represent 'row' and another to represent 'column'.
+Using the form provided, choose which value you would like to appear in the Column and which will appear in the Row.
-If you choose to output to the browser your results will print to the screen.
+ +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).
[% 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 @@ -1,64 +1,23 @@ [% INCLUDE 'help-top.inc' %] -The report dictionary is a way to pre-define common filters you'd like to apply to your reports. This is a good way to add in filters that the report wizard doesn't include by default. To add a new definition, or filter, click 'New Definition' on the Reports Dictionary page and follow the 4 step process.
-Step 1: Name the definition and provide a description if necessary
-Step 1: Name
+Step 2: Choose the module that the will be queried.
-At this step you will need to fill out the following details:
+Step 3: Choose columns to query from the tables presented.
-Step 4: Choose the value(s) from the field(s). These will be automatically populated with options available in your database.
-Step 2: Area
+Confirm your selections to save the definition.
-Now you will need to select the area that you are binding the definition to.
+Your definitions will all appear on the Reports Dictionary page
-IMPORTANT: Definitions can only be bound to one area.
+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.
-TIP: If you wish to use a similar definition in say, Circulation and Patrons, you will need to create two definitions - one for each area
+See the full documentation for the Reports Dictionary in the manual (online).
-Step 3: Columns
- -Now select the criteria that you wish to use to build your definition.
- -TIP: Definitions can be deleted easily, and if you are still learning the structure of the Koha data, it may take a little while to sort out which fields you require. Some trial and error may be required
- -Step 4: Values
- -Now you need to select the values for each column that will make up your new criteria. There are different ways to define the values, based on the type of data in the column you have selected
- -Step 5: Confirmation
- -You will be presented with a confirmation once you have finished step 4
- -Click 'Save'
- -Once you have created your new definition and it shows on in the Dictionary, you can use the definition for reporting.
- -If the report you need is not already available, the 'Guided Reports' Wizard will walk you through creating a custom report.
-Answer the 6 questions presented in order to create your report.
Step 1: Choose a Module to Report on
+Step 2: Pick a Report Type
+Step 3: Select Columns for Display
+Step 4: Select Criteria to Limit
+Step 5: Pick which columns to perform mathmatical functions on
+Step 6: Choose how you want the report ordered
+Can I have reports run on a schedule?
- -Yes, you can use the Task Scheduler tool.
- -Is there a repository for reports?
There is a page on the Koha Wiki: http://wiki.koha-community.org/wiki/SQL_Reports_Library with reports written by Koha libraries around the world.
@@ -55,14 +58,21 @@Can I have run-time defined parameters?
Yes, you can: there is a specific syntax that Koha will understand as 'ask for values when running the report'. The syntax is <<Question to ask|authorised_value>>.
+Note that you can have more than one parameter in a given SQL
+Note that entering nothing at run time won't probably work as you expect. It will be considered as "value empty" not as "ignore this parameter". For example entering nothing for : "title=<<Enter title>>" will display results with title='' (no title). If you want to have to have something not mandatory, use "title like <<Enter title>>" and enter a % at run time instead of nothing
+Sample :
+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 @@ -1,12 +1,13 @@ [% INCLUDE 'help-top.inc' %] -This report will show you how many items were checked out, by borrower (or 'patron') category
+This report will list the average time items are out on loan based on the criteria you enter
-If you choose to output to the browser your results will print to the screen.
+ +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).
+ +[% 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 @@ -1,25 +1,24 @@ [% INCLUDE 'help-top.inc' %] -IMPORTANT: The Circulation 'Wizard' is designed to be a simple statistical snapshot. You will choose a single category to represent 'row' and another to represent 'column'.
-Using the form provided, choose which value you would like to appear in the Column and which will appear in the Row.
+ +If you choose to output to the browser your results will print to the screen.
+ +You can also choose to export to a file that you can manipulate to your needs.
+ +Tip: To get a complete picture of your monthly or daily circulation, you can run the report twice, once for 'Type' of 'Checkout' and again for 'Renewal.'
+ +This report uses 'Period,' or date, filtering that allows you to limit to a month by simply selecting the first day of the first month through the first day of the next month. For example, 10/1 to 11/1 to find statistics for the month of October. + +
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 @@ -14,4 +14,8 @@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 @@ -2,11 +2,12 @@This one-step report will show you how many items of each item type are currently in your branch library or libraries.
- -This report will list the total number of items of each item type per branch.
+ +If you choose to output to the browser your results will print to the screen.
+ +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).
+ +[% 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 @@ -2,13 +2,21 @@Koha comes with a number of predefined (or "canned") reports, along with two report builder engines.
-Pre-defined Reports
-There are number of predefined reports in Koha. Check the Circulation module for additional Circulation specific reports.
-Statistics Wizards
-The statistics wizards provide a way to build simple reports for each module. The reports produced can either be viewed on screen or downloaded for opening in a spreadsheet program or text editor.
-Guided Reports Wizard
-The Guided Reports Wizard helps you build reports using all the fields in the database for each module. The reports can then be saved and run using the scheduler.
[% INCLUDE 'help-bottom.inc' %] +Koha's reporting module allows you to gather data from your system. There are two main types of reports: +
See the full documentation for Reports 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 @@ -2,22 +2,12 @@IMPORTANT: The Serials 'Wizard' is designed to be a simple -statistical snapshot. -
-Using the form provided, choose how you would like to list the serials in your system.
+If you choose to output to the browser your results will print to the screen.
+ +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).
[% INCLUDE 'help-bottom.inc' %] --