Difference between revisions of "Groups and Skills Report"

From Charitylog Manual
Jump to: navigation, search
m
 
(4 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
[[File:helpheader_small.png|right]]
 
[[File:helpheader_small.png|right]]
  
''Location in standard build:'' '''[[Reports Tab]] > "General" section > Memberships/Skills'''.
+
[[File:Menu_groupsskillsrep.png]]
  
 +
Groups and Skills are a useful and versatile system to add people and organisations to multiple categories. It can be used to add, interests to Service Users, Skill sets and job roles to staff and volunteers, memberships and other groupings.
  
[[File:cl_GASR_1.png|border]]
+
{{#ev:youtube|cSX63SARdQA|790}}
  
 +
[[File:Reports_groupsskillscriteria.png]]
  
The Groups and Skills Report allows you to see which people on the system are categorised using the [[Groups and Skills]] feature.
+
* '''Start Date''' - This is the start of the required reporting period.
 
+
* '''End Date''' - The end point of the reporting period.
[[File:cl_GASR_2.png|border]]
 
 
 
 
 
===Report Filters===
 
 
 
You can filter the output by:
 
 
 
* '''Start Date'''
 
* '''End Date'''
 
 
* '''Show Orgs/People with Memberships/Groups which''' - this option works in conjunction with the date fields above, and has options of:
 
* '''Show Orgs/People with Memberships/Groups which''' - this option works in conjunction with the date fields above, and has options of:
** ''Were active for the whole period''
+
** ''Were active for the whole period'' - The date start date on the record needs to be prior to the start date of the reporting period and the end date recorded would be greater than the end date of the reporting period.
** ''Were active for only part of the period''
+
** ''Were active for only part of the period'' - Either the start date or end would need to be between the two reporting period dates.
** ''Were active for part or whole of the period''
+
** ''Were active for part or whole of the period'' - Include both the above two options.
** ''Started and ended during the period''
+
** ''Started and ended during the period'' - Both the recorded start date and end date would be between the two reporting period dates.
** ''Started during the period''
+
** ''Started during the period'' - The recorded start date would be after the start date of the reporting period and before the end date of the reporting period.
** ''Ended during the period''
+
** ''Ended during the period'' - The recorded end date would be after the start date of the reporting period and before the end date of the reporting period.
* '''Show Orgs/People who are''' - choose from "Active", "Not Active", or "Active and Not Active"
+
* '''Show Orgs/People who are''' - Filters on the Active field of the person's/organisations record.
* '''Person/Organisation Category''' - choose particular [[Organisation and People Categories]]
+
* '''Person/Organisation Category''' - Filters using [[Organisation and People Categories]].
* '''"Include"''' options - choose to include or exclude any of the active Organisation/Person Types on the system.
+
* '''Record types''' This is a list of the record types used on your system.  You can specify to either include or exclude each type on the report.
 
** ''Include'' - include anyone with this Type unless later excluded
 
** ''Include'' - include anyone with this Type unless later excluded
 
** ''Exclude'' - exclude anyone with this Type, even if they were previously included by virtue of another Type that they have
 
** ''Exclude'' - exclude anyone with this Type, even if they were previously included by virtue of another Type that they have
 
** ''Not Relevant'' - ignore. ''If you leave all of the Type options set to "Not Relevant", everyone will be included, regardless of Type.''
 
** ''Not Relevant'' - ignore. ''If you leave all of the Type options set to "Not Relevant", everyone will be included, regardless of Type.''
 +
* '''List Order''' - The display order of the report.
  
 +
Click the 'Display in browser' button to run the report or alternatively export to spreadsheet.
  
===Output Options===
+
[[File:Reports_groupsskillsrep.png]]
 
 
* '''List Order''' - order the output by '''Membership Started Date''', '''Memberships Ended Date''', '''Memberships/Groups''' (order by name of the group/skill) or '''Name''' (order by name of the person/organisation).
 
 
 
 
 
===Data Sources===
 
  
This report takes data mainly from the [[Groups and Skills]] feature which appears at the bottom of Organisation/Person [[Details Screen]]s. It also allows filtering by the [[Active Field]] and by Organisation/Person Type.
+
Click on the [[File:Icon_bluefolder.PNG]] icon to go to the [[Blue Folder Lookup]] page.
  
  
 
----
 
----
[[User:Rob Kay|Rob Kay - manual author]] ([[User talk:Rob Kay|talk]]) 15:50, 12 June 2017 (BST)
 
 
[[File:helpheader_small.png|right]]
 
[[File:helpheader_small.png|right]]
[[Category: Reporting]]
 

Latest revision as of 12:52, 18 September 2020

Helpheader small.png

Menu groupsskillsrep.png

Groups and Skills are a useful and versatile system to add people and organisations to multiple categories. It can be used to add, interests to Service Users, Skill sets and job roles to staff and volunteers, memberships and other groupings.

Reports groupsskillscriteria.png

  • Start Date - This is the start of the required reporting period.
  • End Date - The end point of the reporting period.
  • Show Orgs/People with Memberships/Groups which - this option works in conjunction with the date fields above, and has options of:
    • Were active for the whole period - The date start date on the record needs to be prior to the start date of the reporting period and the end date recorded would be greater than the end date of the reporting period.
    • Were active for only part of the period - Either the start date or end would need to be between the two reporting period dates.
    • Were active for part or whole of the period - Include both the above two options.
    • Started and ended during the period - Both the recorded start date and end date would be between the two reporting period dates.
    • Started during the period - The recorded start date would be after the start date of the reporting period and before the end date of the reporting period.
    • Ended during the period - The recorded end date would be after the start date of the reporting period and before the end date of the reporting period.
  • Show Orgs/People who are - Filters on the Active field of the person's/organisations record.
  • Person/Organisation Category - Filters using Organisation and People Categories.
  • Record types This is a list of the record types used on your system. You can specify to either include or exclude each type on the report.
    • Include - include anyone with this Type unless later excluded
    • Exclude - exclude anyone with this Type, even if they were previously included by virtue of another Type that they have
    • Not Relevant - ignore. If you leave all of the Type options set to "Not Relevant", everyone will be included, regardless of Type.
  • List Order - The display order of the report.

Click the 'Display in browser' button to run the report or alternatively export to spreadsheet.

Reports groupsskillsrep.png

Click on the Icon bluefolder.PNG icon to go to the Blue Folder Lookup page.



Helpheader small.png