Attachment 5782 Details for Bug 6966 – Bug 6966 Reports Help

[patch] Bug 6966 Reports Help

Bug-6966-Reports-Help.patch (text/plain), 32.79 KB, created by Nicole C. Engard on 2011-10-07 17:14:23 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nicole C. Engard

Created: 2011-10-07 17:14:23 UTC

Size: 32.79 KB

patch

obsolete

>From ffe087b3fc209e613b89d2821c555698f7c1c093 Mon Sep 17 00:00:00 2001
>From: Nicole C. Engard <nengard@bywatersolutions.com>
>Date: Fri, 7 Oct 2011 13:13:53 -0400
>Subject: [PATCH] Bug 6966 Reports Help
>
>This patch updates all the help files in the reports
>folder and adds links to the manual pages.
>---
> .../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(-)
>
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/acquisitions_stats.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/acquisitions_stats.tt
>index 3740326..63a2f53 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/acquisitions_stats.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/acquisitions_stats.tt
>@@ -2,12 +2,16 @@
> 
> <h1>Acquisitions Statistics</h1>
> 
>-<p style="color: #990000">IMPORTANT:  The Acquisitions 'Wizard' is designed to be a simple statistical snapshot,&nbsp; In each wizard, you will choose a single category to represent 'row' and another to represent 'column'.</p>
>-		<ul>
>-			<li>Go to the 'Reports' module (usually under 'More' in your Global Nav)</li>
>-			<li>Choose 'Acquisitions' under 'Statistics Wizards'</li>
>-			<li>Enter in the information you'd like to see in your repor</li>
>-			<li>Click 'Submit'</li>
>-			<li>By changing the report from 'Count items' to 'Amount' you will see the total spent</li>
>-		</ul>
>-	</div>	[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>+<p>Using the form provided, choose which value you would like to appear in the Column and which will appear in the Row.</p>
>+
>+<p>If you choose to output to the browser your results will print to the screen.</p>
>+
>+<p>You can also choose to export to a file that you can manipulate to your needs.</p>
>+
>+<p>When generating your report, note that you get to choose between counting or summing the values.</p>
>+
>+<p>Choosing amount will change your results to appear as the sum of the amounts spent.</p>
>+
>+<p><strong>See the full documentation for Acquisitions Statistics in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#acqstats">manual</a> (online).</strong></p>
>+
>+[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/bor_issues_top.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/bor_issues_top.tt
>index a4e24f4..384844c 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/bor_issues_top.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/bor_issues_top.tt
>@@ -1,16 +1,13 @@
> [% INCLUDE 'help-top.inc' %]
> 
>-<h1>Patrons with the most checkouts</h1>
>+<h1>Patrons With The Most Checkouts</h1>
> 
>-<p>This guided report will show you which patrons have checked out the most items.</p>
>-		<ul>
>-			<li>Go to the 'Reports' module (usually under 'More' in your Global Nav)</li>
>-			<li>Choose 'Patrons with the most checkouts' under 'Top Lists'</li>
>-			<li>Choose any filters from the top section
>-			<ul>
>-				<li>			   
>-			   IMPORTANT: Choose something other than 'None' from the 'By' field to see results</li>
>-			</ul></li>
>-			<li>Once you have your fields fill in, click 'Submit'</li>
>-		</ul>
>-	</div>	[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>+<p>This report will simply list the patrons who have the most checkouts.</p>
>+
>+<p>If you choose to output to the browser your results will print to the screen.</p>
>+
>+<p>You can also choose to export to a file that you can manipulate to your needs.</p>
>+
>+<p><strong>See the full documentation for the Patrons with the most Checkouts report in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#mostcheckouts">manual</a> (online).</strong></p>
>+
>+[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_out.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_out.tt
>index 2bebbb9..13d88ee 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_out.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_out.tt
>@@ -1,11 +1,13 @@
> [% INCLUDE 'help-top.inc' %]
> 
>-<h1>Patrons who haven't checked out</h1>
>-
>-<p>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</p>
>-		<ul>
>-			<li>Go to the 'Reports' module (usually under 'More' in your Global Nav)</li>
>-			<li>Choose 'Patrons who haven't checked out' under 'Inactive'</li>
>-			<li>If you do not choose any filters or limits, you will see all patrons who have not checked anything out of your library</li>
>-		</ul>
>-	</div>	[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>+<h1>Patrons With No Checkouts</h1>
>+
>+<p>This report will list for you the patrons in your system who haven't checked any items out.</p>
>+
>+<p>If you choose to output to the browser your results will print to the screen.</p>
>+
>+<p>You can also choose to export to a file that you can manipulate to your needs.</p>
>+
>+<p><strong>See the full documentation for the Patrons with no Checkouts report in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#patnocheckouts">manual</a> (online).</strong></p>
>+
>+[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_stats.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_stats.tt
>index 460661b..eeeeca3 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_stats.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/borrowers_stats.tt
>@@ -2,29 +2,13 @@
> 
> <h1>Patron Statistics</h1>
> 
>-<p style="color: #990000">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'.</p>
>-		<ul>
>-			<li>Go to the 'Reports' module (usually under 'More' in your Global Nav)</li>
>-			<li>Choose 'Patrons' under 'Statistics Wizards'</li>
>-			<li>Use the radio button to choose a category for 'row' (In the case above, we've selected 'patron category' for the row
>-			<ul>
>-				<li>Use dropdowns to apply filters to this category</li>
>-			</ul></li>
>-			<li>Use the radio button to choose a category for 'column' (In the case above, we've selected 'branch' for the column)
>-			<ul>
>-				<li> 
>-				<ul>
>-					<li>Use dropdowns to apply filters to this category</li>
>-				</ul></li>
>-			</ul></li>
>-			<li>Options without radio buttons such as 'Patron status', 'Patron activity', and 'Date of Birth' are limits you can place on the report.</li>
>-			<li style="background-color: #ffe599">
>-TIP: To place no limits for a category, choose the blank field. When blank field is chosen all categories will be included in the statistical count.</li>
>-			<li>Choose a method for 'outputting' (viewing) the report: Options are 'browser' or saving as a file viewable in a program like Excel.</li>
>-			<li>Click 'Submit'</li>
>-			<li>For each patron category (rows), there is a count given by branch. Each row and columns are also totaled</li>
>-		</ul>
>-	</div>
>+<p>Using the form provided, choose which value you would like to appear in the Column and which will appear in the Row.</p>
>+
>+<p>If you choose to output to the browser your results will print to the screen.</p>
>+
>+<p>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.</p>
>+
>+<p><strong>See the full documentation for Patron Statistics in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#patstats">manual</a> (online).</strong></p>
> 
> [% INCLUDE 'help-bottom.inc' %]
> 
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/cat_issues_top.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/cat_issues_top.tt
>index f786c3e..90e956e 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/cat_issues_top.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/cat_issues_top.tt
>@@ -1,17 +1,13 @@
> [% INCLUDE 'help-top.inc' %]
> 
>-<h1>Most -Circulated Items</h1>
>+<h1>Most Circulated Items</h1>
> 
>-<p>This guided report will show you which patrons</p>
>+<p>This report will simply list the items that have the been checked out the most.</p>
> 
>-		<ul>
>-			<li>Go to the 'Reports' module (usually under 'More' in your Global Nav)</li>
>-			<li>Choose 'Most-Circulated Items' under 'Top Lists'</li>
>-			<li>Choose any filters from the top section<br/>
>-			<ul>
>-				<li>			   
>-			   IMPORTANT: Choose something other than 'None' from the 'By' field to see results</li>
>-			</ul></li>
>-			<li>Once you have your fields filled in, click 'Submit'</li>
>-		</ul>
>-	</div>	[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>+<p>If you choose to output to the browser your results will print to the screen.</p>
>+
>+<p>You can also choose to export to a file that you can manipulate to your needs.</p>
>+
>+<p><strong>See the full documentation for the Most Circulation Items report in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#mostcirculated">manual</a> (online).</strong></p>
>+
>+[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_out.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_out.tt
>index 168d0c2..5152371 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_out.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_out.tt
>@@ -1,15 +1,13 @@
> [% INCLUDE 'help-top.inc' %]
> 
>-<h1>Items not checked out</h1>
>-
>-<p>This guided report will give you a snapshot of items have not been checked out at all. You can limit these items by branch</p>
>-
>-		<ul>
>-			<li>Go to the 'Reports' module (usually under 'More' in your Global Nav)</li>
>-			<li>Choose 'Items not checked out' under 'Inactive'</li>
>-			<li>If you do not choose any filters or limits, you will see all items that have not been checked out of your library</li>
>-			<li>By choosing a limit you will change the output</li>
>-			<li>Choose a limit of 'Library'</li>
>-			<li>And your results will be sorted by Library code</li>
>-		</ul>
>-	</div>	[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>+<h1>Items With No Checkouts</h1>
>+
>+<p>This report will list items in your collection that have never been checked out.</p>
>+
>+<p>If you choose to output to the browser your results will print to the screen.</p>
>+
>+<p>You can also choose to export to a file that you can manipulate to your needs.</p>
>+
>+<p><strong>See the full documentation for the Issues with no Checkouts report in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#itemnocheckouts">manual</a> (online).</strong></p>
>+
>+[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_stats.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_stats.tt
>index f2f14f6..946b23c 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_stats.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/catalogue_stats.tt
>@@ -1,27 +1,14 @@
> [% INCLUDE 'help-top.inc' %]
> 
>-<h1>   Catalog Statistics</h1>
>+<h1>Catalog Statistics</h1>
> 
>-<p style="color: #990000">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'.</p>
>+<p>Using the form provided, choose which value you would like to appear in the Column and which will appear in the Row.</p>
> 
>-	<ul>
>-		<li>Go to the 'Reports' module (usually under 'More' in your Global Nav)</li>
>-		<li>Choose 'Catalog' under 'Statistics Wizards'</li>
>-		<li>Use the radio button to choose a category for 'row' (In the case above, we've selected 'patron category' for the row
>-		<ul>
>-			<li>Use dropdowns to apply filters to this category</li>
>-		</ul></li>
>-	</ul>
>-	<ul>
>-		<li>Use the radio button to choose a category for 'column' (In the case above, we've selected 'branch' for the column)
>-		<ul>
>-			<li>Use dropdowns to apply filters to this category</li>
>-		</ul></li>
>-	</ul>
>-	<ul>
>-		<li>Choose a method for 'outputting' (viewing) the report: Options are 'browser' or saving as a file viewable in a program like Excel.</li>
>-		<li>Click 'Submit'</li>
>-	</ul>
>+<p>If you choose to output to the browser your results will print to the screen.</p>
>+
>+<p>You can also choose to export to a file that you can manipulate to your needs.</p>
>+
>+<p><strong>See the full documentation for Catalog Statistics in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#catstats">manual</a> (online).</strong></p>
> 
> [% INCLUDE 'help-bottom.inc' %]
> 
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/dictionary.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/dictionary.tt
>index efed210..137883c 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/dictionary.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/dictionary.tt
>@@ -1,64 +1,23 @@
> [% INCLUDE 'help-top.inc' %]
> 
>-<h1>Reports Dictionary Help</h1>
>+<h1>Reports Dictionary</h1>
> 
>-The dictionary provides a way that you can define custom criteria for reporting by combining existing criteria.
>+<p>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.</p>
> 
>-<h2>Adding A New Definition</h2>
>+<p>Step 1: Name the definition and provide a description if necessary</p>
> 
>-<p><strong>Step 1: Name</strong></p>
>+<p>Step 2: Choose the module that the will be queried.</p>
> 
>-<p>At this step you will need to fill out the following details:</p>
>+<p>Step 3: Choose columns to query from the tables presented.</p>
> 
>-<ul>
>-<li>Definition Name: Short name that is used for display and selection</li>
>-<li>Definition Description: Used within the dictionary only to provide further detail about the definition</li>
>-</ul>
>+<p>Step 4: Choose the value(s) from the field(s). These will be automatically populated with options available in your database.</p>
> 
>-<p><strong>Step 2: Area</strong></p>
>+<p>Confirm your selections to save the definition.</p>
> 
>-<p>Now you will need to select the area that you are binding the definition to. </p>
>+<p>Your definitions will all appear on the Reports Dictionary page</p>
> 
>-<p style="color: #990000">IMPORTANT: Definitions can only be bound to one area.</p>
>+<p>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.</p>
> 
>-<p style="background-color: #ffe599">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</p>
>+<p><strong>See the full documentation for the Reports Dictionary in the <a href="http://manual.koha-community.org/3.6/en/reportdic.html">manual</a> (online).</strong></p>
> 
>-<p><strong>Step 3: Columns</strong></p>
>-
>-<p>Now select the criteria that you wish to use to build your definition. </p>
>-
>-<ul>
>-<li>Click on the database column name and then press the 'add' button.</li>
>-<li>Once you have selected all your desired columns, press Next.</li>
>-</ul>
>-
>-<p style="background-color: #ffe599">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</p>
>-
>-<p><strong>Step 4: Values</strong></p>
>-
>-<p>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</p>
>-
>-<ul>
>-<li>Search String Matches For free text fields in that database, enter a string/phrase for the criteria to match on</li>
>-<li>Date For date fields you can either select:</li>
>-<ol><li>Date Range: enter values in both date fields</li>
>-     <li>All Data Before A Given Date: enter a value in the XXX field only</li>
>-     <li>All Data After A Given Date: enter a value in the XXX field only</li>
>-</ol>
>-<li>Select From Database Value For data that is given an authorized value in the Koha database, you the drop down list to select one value</li>
>-</ul>
>-
>-<p><strong>Step 5: Confirmation</strong></p>
>-
>-<p>You will be presented with a confirmation once you have finished step 4</p>
>-
>-<p>Click 'Save'</p>
>-
>-<h2>Using A Definition</h2>
>-
>-<p>Once you have created your new definition and it shows on in the Dictionary, you can use the definition for reporting.</p>
>-
>-<ul>
>-<li>When you go to create a new report, the criteria for the area you are reporting on will automatically show as limits in the Guided Reports wizard</li>
>-</ul>
> [% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tt
>index 240a05a..f89e887 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/guided_reports.tt
>@@ -4,7 +4,6 @@
> 
> <p>If the report you need is not already available, the 'Guided Reports' Wizard will walk you through creating a custom report.</p>
> 
>-
> <ul>
> <li>Go to the 'Reports' module (usually under 'More' in your Global Nav)</li>
> <li>Choose 'Guided Reports' under 'Guided Reports Wizard'</li>
>@@ -13,19 +12,28 @@
> <p>Answer the 6 questions presented in order to create your report.</p>
> 
> <p><strong>Step 1: Choose a Module to Report on</strong></p>
>+
> <ul>
> <li>Choose a Koha module to build a report on (patrons, circ, cataloging, etc)</li>
> <li>Click 'Next'</li>
> </ul>
> 
> <p><strong>Step 2: Pick a Report Type</strong></p>
>+
> <ul><li style="color: #990000">IMPORTANT: Only Tabular should be chosen with this option</li></ul>
>+
> <p><strong>Step 3: Select Columns for Display</strong></p>
>+
> <p><strong>Step 4: Select Criteria to Limit</strong></p>
>+
> <ul><li>This is optional, if you don't want to limit results by any one field, just leave this section blank.</li></ul>
>+
> <p><strong>Step 5: Pick which columns to perform mathmatical functions on</strong></p>
>+
> <ul><li>This is optional, if you don't want to do any math on the results, just leave this section blank.</li></ul>
>+
> <p><strong>Step 6: Choose how you want the report ordered</strong></p>
>+
> <ul><li>This is optional, if you want the results to come out as they are in the table, just leave this section blank.</li></ul>
> 
> <h1>Edit Reports</h1>
>@@ -34,18 +42,13 @@
> 
> <ul><li><em>Get there:</em> More > Reports > Guided Reports > Use Saved</li></ul>
> 
>-<ul><li>To edit a report click 'Edit SQL' beside the report</li>
>-<li>A page with editable fields will open so that you can change the title, notes and SQL related to the report</li></ul>
>-
>+<ul>
>+<li>To edit a report click 'Edit SQL' beside the report</li>
>+<li>A page with editable fields will open so that you can change the title, notes and SQL related to the report</li>
>+</ul>
> 
> <h1>Questions</h1>
> 
>-<p><strong>Can I have reports run on a schedule?</strong></p>
>-
>-<p>Yes, you can use the Task Scheduler tool.</p>
>-
>-<ul><li><em>Get there:</em> More > Tools > Task Scheduler</li></ul>
>-
> <p><strong>Is there a repository for reports?</strong></p>
> 
> <p>There is a page on the Koha Wiki: <a href="http://wiki.koha-community.org/wiki/SQL_Reports_Library" target="_new">http://wiki.koha-community.org/wiki/SQL_Reports_Library</a> with reports written by Koha libraries around the world.</p>
>@@ -55,14 +58,21 @@
> <p><strong>Can I have run-time defined parameters?</strong></p>
> 
> <p>Yes, you can: there is a specific syntax that Koha will understand as 'ask for values when running the report'. The syntax is &lt;&lt;Question to ask|authorised_value&gt;&gt;.</p>
>+
> <ul>
> <li>The &lt;&lt; and &gt;&gt; are just delimiters. You must put &lt;&lt; at the beginning and &gt;&gt; at the end of your parameter</li>
> <li>The <strong>Question to ask</strong> will be displayed on the left of the string to enter. 
> <li>The <strong>authorised_value</strong> can be omitted if not applicable. If it contains an authorised value category, or <strong>branches</strong> or <strong>itemtype</strong> or <strong>categorycode</strong>, a list with the Koha authorised values will be displayed instead of a free field</li>
> </ul>
>+
> <p>Note that you can have more than one parameter in a given SQL</p>
>+
> <p>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=&lt;&lt;Enter title&gt;&gt;" will display results with title='' (no title). If you want to have to have something not mandatory, use "title like &lt;&lt;Enter title&gt;&gt;" and enter a % at run time instead of nothing</p>
>+
> <p>Sample :</p>
>+
> <ul><li>SELECT surname,firstname FROM borrowers WHERE branchcode=&lt;&lt;Enter patrons library|branches&gt;&gt; AND surname like &lt;&lt;Enter filter for patron surname (% if none)&gt;&gt;</li></ul>
> 
>+<p><strong>See the full documentation for Custom Reports in the <a href="http://manual.koha-community.org/3.6/en/reports.html#customreports">manual</a> (online).</strong></p>
>+
> [% INCLUDE 'help-bottom.inc' %]
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_avg_stats.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_avg_stats.tt
>index 03b126e..5b83f72 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_avg_stats.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_avg_stats.tt
>@@ -1,12 +1,13 @@
> [% INCLUDE 'help-top.inc' %]
> 
>-<h1>Average loan time</h1>
>+<h1>Average Loan Time</h1>
> 
>-<p>This report will show you how many items were checked out, by borrower (or 'patron') category</p>
>+<p>This report will list the average time items are out on loan based on the criteria you enter</p>
> 
>-		<ul>
>-			<li>Go to the 'Reports' module (usually under 'More' in your Global Nav)</li>
>-			<li>Choose 'Average loan time' under 'Other'</li>
>-			<li>Choose one field to appear in the rows and another to appear in the column.  If you choose either of the date fields remember to choose to show data by 'Day', 'Month', or 'Year'</li>
>-		</ul>
>-	</div>	[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>+<p>If you choose to output to the browser your results will print to the screen.</p>
>+
>+<p>You can also choose to export to a file that you can manipulate to your needs.</p>
>+
>+<p><strong>See the full documentation for the Average Loan Time report in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#avloantime">manual</a> (online).</strong></p>
>+
>+[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_stats.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_stats.tt
>index b54f6f3..9a36808 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_stats.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/issues_stats.tt
>@@ -1,25 +1,24 @@
> [% INCLUDE 'help-top.inc' %]
> 
>-<h1>   Circulation Statistics</h1>
>-
>-<p style="color: #990000">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'.</p>
>-		<ul>
>-			<li>Go to the 'Reports' module (usually under 'More' in your Global Navigation)</li>
>-			<li>Choose 'Circulation' under 'Statistics Wizards'</li>
>-			<li>Select the information you want to display in rows by setting the 'Row' radio button next to that category</li>
>-			<li>Select the information you want to display in columns by setting the 'Column' radio button next to that category.</li>
>-			<li>You can limit, or Filter, your results by selecting a value from the pull down menu.  For example, you could select a specific library or branch and set a time 'Period,' without needing to select those radio buttons.</li>
>-		</ul>
>-<strong>Tips:</strong>
>-	<ul>
>-		<li>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.'</li>
>-		<li>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.</li>
>-			<ul>
>-				<li>To find daily statistics, set your date range.</br> Example: "I want circulation data starting with date XXX up to, but not including, date XXX."</li>
>-				<li>For a whole month, an example range would be: 11/01/2009 to 12/01/2009</li> 
>-				<li>For a whole year, an example range would be: 01/01/2009 to 01/01/2010</li>
>-				<li>For a single day, an example would be: 11/15/2009 to 11/16/2009 to find what circulated on the 15th</li>
>-			</ul>
>-	</ul>
>-	</div>
>+<h1>Circulation Statistics</h1>
>+
>+<p>Using the form provided, choose which value you would like to appear in the Column and which will appear in the Row.</p>
>+
>+<p>If you choose to output to the browser your results will print to the screen.</p>
>+
>+<p>You can also choose to export to a file that you can manipulate to your needs.</p>
>+
>+<p style="background-color: #ffe599">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.'</p>
>+
>+<p>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.
>+
>+<ul>
>+	<li>To find daily statistics, set your date range.Example: "I want circulation data starting with date XXX up to, but not including, date XXX."</li>
>+	<li>For a whole month, an example range would be: 11/01/2009 to 12/01/2009</li>
>+	<li>For a whole year, an example range would be: 01/01/2009 to 01/01/2010</li>
>+	<li>For a single day, an example would be: 11/15/2009 to 11/16/2009 to find what circulated on the 15th</li>
>+</ul>
>+
>+<p><strong>See the full documentation for Circulation Statistics in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#circstats">manual</a> (online).</strong></p>
>+
> [% INCLUDE 'help-bottom.inc' %]
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/itemslost.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/itemslost.tt
>index b632a45..425a31d 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/itemslost.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/itemslost.tt
>@@ -14,4 +14,8 @@
> 			<li>Choose a 'Lost Status' to search only for items that are assumed lost (long overdue), missing, or lost (or, leave this set to 'All' to see all lost items)</li>
> 			<li>Click 'Submit'</li>
> 		</ul>
>-	</div>	[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>+	</div>	
>+
>+<p><strong>See the full documentation for the Lost Items report in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#lostreport">manual</a> (online).</strong></p>
>+	
>+[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/manager.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/manager.tt
>index e2e9e6d..37d686c 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/manager.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/manager.tt
>@@ -2,11 +2,12 @@
> 
> <h1>Catalog by Item Type</h1>
> 
>-<p>This one-step report will show you how many items of each item type are currently in your branch library or libraries.</p>
>-
>-	<ul>
>-		<li>Go to the 'Reports' module (usually under 'More' in your Global Nav)</li>
>-		<li>Choose 'Catalog by Item Type' under 'Other'</li>
>-		<li>Choose a branch (or choose the blank field at the top of the dropdown menu to choose all branches)</li>
>-		<li>Click 'Submit'</li>
>-	</ul>[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>+<p>This report will list the total number of items of each item type per branch.</p>
>+
>+<p>If you choose to output to the browser your results will print to the screen.</p>
>+
>+<p>You can also choose to export to a file that you can manipulate to your needs.</p>
>+
>+<p><strong>See the full documentation for the Catalog by Item Type report in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#catbyitem">manual</a> (online).</strong></p>
>+
>+[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/reports-home.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/reports-home.tt
>index 7ebc985..a20a122 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/reports-home.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/reports-home.tt
>@@ -2,13 +2,21 @@
> 
> <h1>Reports</h1>
> 
>-<h2>What Reports are there in Koha?</h2>
>- 
>-<p>Koha comes with a number of predefined (or &quot;canned&quot;) reports, along with two report builder engines.</p>
>-<p><strong>Pre-defined Reports</strong></p>
>-<p>There are number of predefined reports in Koha. Check the Circulation module for additional Circulation specific reports.</p>
>-<p><strong>Statistics Wizards</strong></p>
>-<p>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.</p>
>-<p><strong>Guided Reports Wizard</strong></p>
>-<p>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. </p>[% INCLUDE 'help-bottom.inc' %]
>+<p>Koha's reporting module allows you to gather data from your system.  There are two main types of reports:
> 
>+<ul>
>+	<li>Custom Reports
>+<ul>
>+	<li>Koha's data is stored in a MySQL database which means that librarians can generate nearly any report they would like by either using the Guided Reports Wizard or writing their own SQL query.</li>
>+</ul>
>+</li>
>+	<li>Statistical Reports
>+<ul>
>+	<li>Statistic reports will show you counts and sums. These reports are all about numbers and statistics, for reports that return more detailed data, use the Guided Report Wizard.</li>
>+</ul>
>+</li>
>+</ul>
>+
>+<p><strong>See the full documentation for Reports in the <a href="http://manual.koha-community.org/3.6/en/reports.html">manual</a> (online).</strong></p>
>+
>+[% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/serials_stats.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/serials_stats.tt
>index 79a941d..cba7247 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/serials_stats.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/help/reports/serials_stats.tt
>@@ -2,22 +2,12 @@
> 
> <h1>Serials Statistics</h1>
> 
>-<p style="color: #990000">IMPORTANT: The Serials 'Wizard' is designed to be a simple
>-statistical snapshot. 
>-</p>
>-<ul>
>-	<li>
>-	Go to the 'Reports' module (usually under 'More' in your Global Nav)
>-	</li>
>-	<li>
>-	Choose 'Serials' under 'Statistics Wizards'</li>
>-	<li>Choose
>-	your vendor and branch (or leave them both set to 'Any' to get
>-	information on all subscriptions) and whether to include expired
>-	subscriptions</li>
>-	<li>Your results will appear as a list of subscriptions
>-	</li>
>-</ul>
>+<p>Using the form provided, choose how you would like to list the serials in your system.</p>
> 
>+<p>If you choose to output to the browser your results will print to the screen.</p>
>+
>+<p>You can also choose to export to a file that you can manipulate to your needs.</p>
>+
>+<p><strong>See the full documentation for Serials Statistics in the <a href="http://manual.koha-community.org/3.6/en/statsreports.html#serialstats">manual</a> (online).</strong></p>
> 
> [% INCLUDE 'help-bottom.inc' %]
>\ No newline at end of file
>-- 
>1.7.2.3

Actions: View | Diff | Splinter Review

Attachments on bug 6966: 5694 | 5704 | 5715 | 5716 | 5717 | 5718 | 5741 | 5742 | 5743 | 5744 | 5747 | 5748 | 5779 | 5782 | 5783 | 5784 | 5785 | 5786 | 5787 | 5788 | 5789 | 5790 | 6007 | 6184