Difference between revisions of "Courses and Qualifications Report"

From Charitylog Manual
Jump to: navigation, search
 
(14 intermediate revisions by 4 users not shown)
Line 1: Line 1:
[[File:helpheader_small.png|right]]
+
[[File:course_qual1.jpg|400px|alt="a screenshot of the courses and qualifications report button in the report menu."]]
 
 
''Location in standard build:'' '''[[Reports Tab]] > "General" section > Courses & Qualifications'''
 
 
 
[[file:cl_CAQR_1.png]]
 
 
 
 
 
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:cl_CAQR_2.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 reports on both Courses and Qualifications that are added to records via the [[Organisations_and_People#Blue_Links|Blue Links]] at the bottom. [https://wiki.charitylog.co.uk/index.php?title=Courses_and_Qualifications Click here] to see how to add Courses & Qualifications. The webinar below explains how to run the report. Additional information is below.
 +
{{#ev:youtube|fP6XZkBKPiA|790}}
  
This report takes data from information entered in the [[Courses]] and [[Qualifications]] sections at the bottom of organisation/people Details screens.
+
[[File:course_qual2.jpg|700px|alt="a screenshot of the courses and qualifications report criteria fields, as listed below."]]
  
The drop-down list which gives users the options to enter in these sections is [[Courses and Qualifications]].
+
* '''Start Date''' - Select the earliest date to report from, courses and qualifications dated before this will be excluded.
 +
* '''End Date''' - Select the latest date to report to, courses and qualifications dated after this will be excluded.
 +
* '''Type?''' - Specify to report on all or just courses or qualifications.
 +
* '''Expiry Status''' - You can filter by expired or current if required.
 +
* '''Courses''' - If reporting on courses select the courses required, or select 'All Courses'.
 +
* '''Qualifications''' - If reporting on qualifications select the qualifications required, or select 'All qualifications'.
 +
* '''Order By''' - Select the display order of the report.
 +
 +
[[File:course_qual3.jpg|700px|alt="a screenshot of the courses and qualifications report results."]]
  
 +
Each section and the total will have the [[File:Icon_bluefolder.PNG|link=Blue Folder Lookup]] Icon to access the [[Blue Folder Lookup]] screen.
 
----
 
----
[[User:Rob Kay|Rob Kay - manual author]] ([[User talk:Rob Kay|talk]]) 14:46, 12 June 2017 (BST)
 
 
[[File:helpheader_small.png|right]]
 
[[File:helpheader_small.png|right]]
[[Category:Reporting]]
 

Latest revision as of 08:45, 21 May 2024

"a screenshot of the courses and qualifications report button in the report menu."

This reports on both Courses and Qualifications that are added to records via the Blue Links at the bottom. Click here to see how to add Courses & Qualifications. The webinar below explains how to run the report. Additional information is below.

"a screenshot of the courses and qualifications report criteria fields, as listed below."

  • Start Date - Select the earliest date to report from, courses and qualifications dated before this will be excluded.
  • End Date - Select the latest date to report to, courses and qualifications dated after this will be excluded.
  • Type? - Specify to report on all or just courses or qualifications.
  • Expiry Status - You can filter by expired or current if required.
  • Courses - If reporting on courses select the courses required, or select 'All Courses'.
  • Qualifications - If reporting on qualifications select the qualifications required, or select 'All qualifications'.
  • Order By - Select the display order of the report.

"a screenshot of the courses and qualifications report results."

Each section and the total will have the Icon bluefolder.PNG Icon to access the Blue Folder Lookup screen.


Helpheader small.png