Difference between revisions of "Courses and Qualifications Report"

From Charitylog Manual
Jump to: navigation, search
(Added correct picture for top of page)
m
 
(16 intermediate revisions by 3 users not shown)
Line 1: Line 1:
[[file:CAQR_1.png|right]]
+
[[File:helpheader_small.png|right]]
''Location in standard build:'' '''Reports > Office Reports > Courses and Qualifications Report'''
 
  
The Courses and Qualifications report shows which people completed a particular course, or held a particular qualification, over a time frame.
+
[[File:Menu_caqreport.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]]
  
__TOC__
+
* '''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:Reports_candqreport.png]]
  
 
+
Each section and the total will have the [[File:Icon_bluefolder.PNG|link=Blue Folder Lookup]] Icon to access the [[Blue Folder Lookup]] screen.
[[File:RAO_3.png|border]]
+
----
 
+
[[File:helpheader_small.png|right]]
 
 
==Control of reporting output==
 
 
 
===Filters===
 
 
 
The report can be filtered by:
 
 
 
* Course, or a range of courses
 
* 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===
 
 
 
The output can be ordered by:
 
 
 
* Name (of the person holding the courses/qualifications)
 
* Name 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==
 
 
 
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]].
 
 
 
 
 
[[User:Rob Kay|Rob Kay - manual author]] ([[User talk:Rob Kay|talk]]) 13:02, 24 April 2014 (BST)
 

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