Difference between revisions of "Courses and Qualifications Report"

From Charitylog Manual
Jump to: navigation, search
Line 1: Line 1:
[[file:CAQR_1.png|right]]
+
[[File:helpheader_small.png]]
 +
 
 
''Location in standard build:'' '''[[Reports Tab]] > "General" section > Courses & Qualifications'''
 
''Location in standard build:'' '''[[Reports Tab]] > "General" section > Courses & Qualifications'''
  
 
The Courses & Qualifications Report is a report which takes data from the [[Courses]] and [[Qualifications]] features. It is usually used to show which people completed a particular course, or held a particular qualification, over a time frame.
 
The Courses & Qualifications Report is a report which takes data from the [[Courses]] and [[Qualifications]] features. It is usually used to show which people completed a particular course, or held a particular qualification, over a time frame.
  
 +
[[file:CAQR_1.png]]
  
__TOC__
 
 
 
[[File:RAO_3.png|border]]
 
 
 
==Control of reporting output==
 
  
 
===Filters===
 
===Filters===
  
The report can be filtered by:
+
You can filter the reporting output by:
  
 +
* '''Start Date''' and '''End Date''' - note that this date range filter refers '''only''' to the date that a course/qualification was obtained, i.e. the start date. The date of expiry of [[Courses]] and [[Qualifications]] is not included in this date filter.
 +
* '''Type?''' - choose from [[Courses]] or [[Qualifications]] as appropriate
 +
* '''Expiry Status''' - choose from "All Records", "Expired" or "Current" - this is worked out by whether the date of expiry is before or after today (Courses and Qualifications that expire ''today'' are regarded as current)
 
* Course, or a range of courses
 
* Course, or a range of courses
 
* Qualification, or a range of qualifications
 
* Qualification, or a range of qualifications
 
You can combine these two filters (i.e. you can report on one course and one qualification, or a range of courses and a range of qualifications, etc). You can select more than one course by holding "shift" and clicking, which selects adjacent options; you can also select more than one course by holding "ctrl" [on Windows] and clicking options, which will allow you to select more than one option when they are not adjacent.
 
 
  
 
===Output formats===
 
===Output formats===
Line 30: Line 25:
 
* Name of course/qualification
 
* Name of course/qualification
 
* Date of course/qualification
 
* Date of course/qualification
 
The usual output options are available: Display/Print (which shows the output on screen) and Export (which creates an Excel spreadsheet).
 
  
  
 
==Data Sources==
 
==Data Sources==
  
This report takes data from information entered in the "Courses" and "Qualifications" sections at the bottom of organisation/people Details screens.
+
This report takes data from information entered in the [[Course]] and[[Qualifications]] sections at the bottom of organisation/people Details screens.
  
 
The drop-down list which gives users the options to enter in these sections is [[Courses and Qualifications]].
 
The drop-down list which gives users the options to enter in these sections is [[Courses and Qualifications]].

Revision as of 13:44, 12 June 2017

Helpheader small.png

Location in standard build: Reports Tab > "General" section > Courses & Qualifications

The Courses & Qualifications Report is a report which takes data from the Courses and Qualifications features. It is usually used to show which people completed a particular course, or held a particular qualification, over a time frame.

File:CAQR 1.png


Filters

You can filter the reporting output by:

  • Start Date and End Date - note that this date range filter refers only to the date that a course/qualification was obtained, i.e. the start date. The date of expiry of Courses and Qualifications is not included in this date filter.
  • Type? - choose from Courses or Qualifications as appropriate
  • Expiry Status - choose from "All Records", "Expired" or "Current" - this is worked out by whether the date of expiry is before or after today (Courses and Qualifications that expire today are regarded as current)
  • Course, or a range of courses
  • Qualification, or a range of qualifications

Output formats

The output can be ordered by:

  • Name (of the person holding the courses/qualifications)
  • Name of course/qualification
  • Date of course/qualification


Data Sources

This report takes data from information entered in the Course andQualifications sections at the bottom of organisation/people Details screens.

The drop-down list which gives users the options to enter in these sections is Courses and Qualifications.


Rob Kay - manual author (talk) 13:02, 24 April 2014 (BST)