Difference between revisions of "Groups and Skills Report"

From Charitylog Manual
Jump to: navigation, search
Line 10: Line 10:
 
* '''End Date''' - The end point of the 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:
 
* '''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.
 
 
===Output Options===
 
 
 
* '''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===
 
===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.
 
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.
 
  
 
----
 
----
[[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]]
 

Revision as of 14:41, 11 September 2018

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.

Data Sources

This report takes data mainly from the Groups and Skills feature which appears at the bottom of Organisation/Person Details Screens. It also allows filtering by the Active Field and by Organisation/Person Type.


Helpheader small.png