Difference between revisions of "Courses and Qualifications Report"

From Charitylog Manual
Jump to: navigation, search
m
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
[[File:helpheader_small.png|right]]
 
[[File:helpheader_small.png|right]]
  
''Location in standard build:'' '''[[Reports Tab]] > "General" section > Courses & Qualifications'''
+
[[File:Menu_caqreport.png]]
  
[[file:cl_CAQR_1.png]]
+
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}}
  
 +
[[File:Reports_candqcriteria.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.
+
* '''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.
[[file:cl_CAQR_2.png]]
+
* '''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'.
===Filters===
+
* '''Qualifications''' - If reporting on qualifications select the qualifications required, or select 'All qualifications'.
 
+
* '''Order By''' - Select the display order of the report.
You can filter the reporting output by:
+
 
+
[[File:Reports_candqreport.png]]
* '''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 [[Courses]] 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]].
 
  
 +
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 14:32, 30 September 2020

Helpheader small.png

Menu caqreport.png

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.

Reports candqcriteria.png

  • 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.

Reports candqreport.png

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


Helpheader small.png