Difference between revisions of "Extension Database Reports"

From Charitylog Manual
Jump to: navigation, search
(Report Criteria)
(Report Settings)
 
(6 intermediate revisions by the same user not shown)
Line 14: Line 14:
 
Click on the name of the extension database that you wish to report on.
 
Click on the name of the extension database that you wish to report on.
  
=Report Criteria=
+
=Report Settings=
  
 
You will be displayed a list of fields based on the type of extension database and the fields in the extension database. Regardless of the type, you will see the Settings options at the top. This allows you to select from the following options:
 
You will be displayed a list of fields based on the type of extension database and the fields in the extension database. Regardless of the type, you will see the Settings options at the top. This allows you to select from the following options:
  
* '''Types of fields to show''' - you can choose from Active, reportable fields (the default), active fields whether reportable or not, Reportable fields whether active or not, All fields. This option is useful if you just want the required reportable data or if you want to audit all fields used.
+
* '''Types of fields to show''' - you can choose from ''Active, reportable fields'' (the default), ''Active fields whether reportable or not'', ''Reportable fields whether active or not'', ''All fields.'' This option is useful if you just want the required reportable data or if you want to audit all fields used.
 
* '''Show Audit Fields''' - Will add a column to the report showing the user who created the entry and the date it was updated/created.
 
* '''Show Audit Fields''' - Will add a column to the report showing the user who created the entry and the date it was updated/created.
 
* '''Show Subtotals''' - Useful if you want the report to automatically sum the entries.  
 
* '''Show Subtotals''' - Useful if you want the report to automatically sum the entries.  
Line 26: Line 26:
  
 
==Person/Organisation based==
 
==Person/Organisation based==
These extension databases appear either on the tabs of the record or at the base of the record.  On the diagram below the fields of the extension database are highlighted by the red box.
+
These extension databases appear either on sections of a record eg a client record.  These could be custom fields added to the section, or an entirely new extension database such as an assessment or outcome.  
  
 
[[File:Extdbrep_personfields.png]]
 
[[File:Extdbrep_personfields.png]]
  
* '''Client Surname''' - Enter the surname or organisation name to filter the results.
+
In the '''Record Filters''' section you can filter your report by:
* '''Client ID Number''' - Enter the ID number of a person or organisation to filter the results.
+
 
* '''Linked to Active Organisations and People?''' - Specify if you wish to include inactive records.
+
* '''Date Record Created''' - note this might be different if you have a Date Completed field on the actual extension database.  
* '''The fields in the extension database''' - Depending on which fields are in the extension database these will be listed so that you can filter on these fields.
+
* '''Date Record Updated'''  
** '''Single Row Alphanumeric String''' - You will be displayed a single line text box to filter from.
+
 
** '''Numeric Only''' - This will display a from and to box to filter using a numeric range.
+
In the '''Org/People Filters''' section you can filter your report by:
** '''Money''' - This will display a from and to box to filter using a numeric range.
+
 
** '''Date''' -  - This will display a from and to date box to filter using a date range.
+
* '''Surname''' - Enter the surname or organisation name to filter the results.
** '''Multi row text input box''' - This displays a text box to filter from, exact text match on part of a single word or sentence.
+
* '''Org Person ID No.''' - Enter the ID number of a person or organisation to filter the results.
** '''Select from options list''' - Displays the drop down of options so you can filter from one of the options.
+
* '''Person/Organisation Category'''  
** '''Radio Button list''' - select the option you use to use as a filter.
+
* '''Linked to Active Orgs and People''' - it will default to active records only.  
* '''Report Sort By''' - Specify the sort order of the report.
+
 
* '''Show Subtotals When Sorted?''' - Displays subtotals for numeric and currency fields on the report.
+
The '''Field Filters''' section will then list all the fields used on that particular extension database.  
* '''Show Active or Inactive fields?''' - Specify if you wish to include fields that have been made inactive.
 
  
 
Click 'Display in browser' to view the report and/or to add additional information or 'Export to spreadsheet' to create a spreadsheet of the data.
 
Click 'Display in browser' to view the report and/or to add additional information or 'Export to spreadsheet' to create a spreadsheet of the data.
  
 
==Referral based==
 
==Referral based==
This type of extension database is connected to referrals.
+
This type of extension database is connected to referrals.  
  
 
[[File:Extdbrep_referralfields.png]]
 
[[File:Extdbrep_referralfields.png]]
 +
 +
As with the Org/People linked records, you have the '''Settings''', '''Record Filters''' and '''Org/People filters.'''. Because these are linked to referrals you can now filter by:
  
 
* '''Referral Date''' - Filters based on the date that the referral was created.
 
* '''Referral Date''' - Filters based on the date that the referral was created.
 
* '''Project''' - Reports on all projects or the project selected.
 
* '''Project''' - Reports on all projects or the project selected.
* '''Diary Reference Number''' - Specify the range of referral numbers you wish to filter by.
+
* '''Referral ID''' - Specify the range of referral numbers you wish to filter by.
* '''Client Surname''' - Enter the surname or organisation name to filter the results.
+
* '''Referred by''' - choose the referrer
* '''Client ID Number''' - Enter the ID number of a person or organisation to filter the results.
+
 
* '''Linked to Active Organisations and People?''' - Specify if you wish to include inactive records.
+
As before, you also have the '''Field Filter''' options which will display all fields used by that extension database.  
* '''The fields in the extension database''' - Depending on which fields are in the extension database these will be listed so that you can filter on these fields.
 
** '''Single Row Alphanumeric String''' - You will be displayed a single line text box to filter from.
 
** '''Numeric Only''' - This will display a from and to box to filter using a numeric range.
 
** '''Money''' - This will display a from and to box to filter using a numeric range.
 
** '''Date''' -  - This will display a from and to date box to filter using a date range.
 
** '''Multi row text input box''' - This displays a text box to filter from, exact text match on part of a single word or sentence.
 
** '''Select from options list''' - Displays the drop down of options so you can filter from one of the options.
 
** '''Radio Button list''' - select the option you use to use as a filter.
 
* '''Report Sort By''' - Specify the sort order of the report.
 
* '''Show Subtotals When Sorted?''' - Displays subtotals for numeric and currency fields on the report.
 
* '''Show Active or Inactive fields?''' - Specify if you wish to include fields that have been made inactive.
 
  
 
Click 'Display in browser' to view the report and/or to add additional information or 'Export to spreadsheet' to create a spreadsheet of the data.
 
Click 'Display in browser' to view the report and/or to add additional information or 'Export to spreadsheet' to create a spreadsheet of the data.
Line 75: Line 65:
  
 
[[File:Extdbrep_clubsfields.png]]
 
[[File:Extdbrep_clubsfields.png]]
 +
 +
As with the Org/People linked records, you have the '''Settings''', '''Record Filters''' but you also have the '''Club or Clinic Filters''' section. You can filter results by:
  
 
* '''Club / Clinic / Group Name''' - Enter the name Club, Clinic or Group to use as a report filter.
 
* '''Club / Clinic / Group Name''' - Enter the name Club, Clinic or Group to use as a report filter.
 
* '''Linked to Active Clubs & Groups?''' - Specify if you wish to include inactive Clubs, Clinics or Groups.
 
* '''Linked to Active Clubs & Groups?''' - Specify if you wish to include inactive Clubs, Clinics or Groups.
* '''The fields in the extension database''' - Depending on which fields are in the extension database these will be listed so that you can filter on these fields.
+
 
** '''Single Row Alphanumeric String''' - You will be displayed a single line text box to filter from.
+
You also have the '''Field Filter''' options which will display all fields used by that extension database.
** '''Numeric Only''' - This will display a from and to box to filter using a numeric range.
 
** '''Money''' - This will display a from and to box to filter using a numeric range.
 
** '''Date''' -  - This will display a from and to date box to filter using a date range.
 
** '''Multi row text input box''' - This displays a text box to filter from, exact text match on part of a single word or sentence.
 
** '''Select from options list''' - Displays the drop down of options so you can filter from one of the options.
 
** '''Radio Button list''' - select the option you use to use as a filter.
 
* '''Show Subtotals When Sorted?''' - Displays subtotals for numeric and currency fields on the report.
 
* '''Show Active or Inactive fields?''' - Specify if you wish to include fields that have been made inactive.
 
  
 
Click 'Display in browser' to view the report and/or to add additional information or 'Export to spreadsheet' to create a spreadsheet of the data.
 
Click 'Display in browser' to view the report and/or to add additional information or 'Export to spreadsheet' to create a spreadsheet of the data.
Line 93: Line 77:
 
=Display in Browser=
 
=Display in Browser=
  
This will display the report based on the specified criteria.
+
This will display the report based on the specified criteria. In the example below you will notice it does not include the audit fields, nor is it subtotalling any results.  
  
 
[[File:extdbrep_rep.png|border]]
 
[[File:extdbrep_rep.png|border]]
Line 101: Line 85:
 
=Export to spreadsheet=
 
=Export to spreadsheet=
  
This will produce spreadsheet of the data based on the report criteria entered.
+
This will produce spreadsheet of the data based on the report criteria entered. You can now perform additional data analysis such as a [https://wiki.dizions.co.uk/index.php/Tables_(Excel) Pivot Table] using this raw data.  
  
 
[[File:extdbrep_export.png]]
 
[[File:extdbrep_export.png]]

Latest revision as of 13:33, 14 April 2023

Helpheader small.png

Cl EDR 1.png

Extension Database Selection

Extension databases are bespoke sets of fields set up on the system by the administrator. From here you are able to report directly on these extension databases. On the first screen you will be presented the list of active extension databases on the system.

You will see a list of all Published extension databases available to report on. You can also switch between Archived extension databases if you wish to report on data which is no longer being used. There is also a filter option which makes it easier to find reports.

Listalledbreports.png

Click on the name of the extension database that you wish to report on.

Report Settings

You will be displayed a list of fields based on the type of extension database and the fields in the extension database. Regardless of the type, you will see the Settings options at the top. This allows you to select from the following options:

  • Types of fields to show - you can choose from Active, reportable fields (the default), Active fields whether reportable or not, Reportable fields whether active or not, All fields. This option is useful if you just want the required reportable data or if you want to audit all fields used.
  • Show Audit Fields - Will add a column to the report showing the user who created the entry and the date it was updated/created.
  • Show Subtotals - Useful if you want the report to automatically sum the entries.
  • Order - you can decide to order the results by date, client name, or by certain fields on the extension database.

EDBsettings.png

Person/Organisation based

These extension databases appear either on sections of a record eg a client record. These could be custom fields added to the section, or an entirely new extension database such as an assessment or outcome.

Extdbrep personfields.png

In the Record Filters section you can filter your report by:

  • Date Record Created - note this might be different if you have a Date Completed field on the actual extension database.
  • Date Record Updated

In the Org/People Filters section you can filter your report by:

  • Surname - Enter the surname or organisation name to filter the results.
  • Org Person ID No. - Enter the ID number of a person or organisation to filter the results.
  • Person/Organisation Category
  • Linked to Active Orgs and People - it will default to active records only.

The Field Filters section will then list all the fields used on that particular extension database.

Click 'Display in browser' to view the report and/or to add additional information or 'Export to spreadsheet' to create a spreadsheet of the data.

Referral based

This type of extension database is connected to referrals.

Extdbrep referralfields.png

As with the Org/People linked records, you have the Settings, Record Filters and Org/People filters.. Because these are linked to referrals you can now filter by:

  • Referral Date - Filters based on the date that the referral was created.
  • Project - Reports on all projects or the project selected.
  • Referral ID - Specify the range of referral numbers you wish to filter by.
  • Referred by - choose the referrer

As before, you also have the Field Filter options which will display all fields used by that extension database.

Click 'Display in browser' to view the report and/or to add additional information or 'Export to spreadsheet' to create a spreadsheet of the data.

Club, Clinic or Group based

Extdbrep clubsfields.png

As with the Org/People linked records, you have the Settings, Record Filters but you also have the Club or Clinic Filters section. You can filter results by:

  • Club / Clinic / Group Name - Enter the name Club, Clinic or Group to use as a report filter.
  • Linked to Active Clubs & Groups? - Specify if you wish to include inactive Clubs, Clinics or Groups.

You also have the Field Filter options which will display all fields used by that extension database.

Click 'Display in browser' to view the report and/or to add additional information or 'Export to spreadsheet' to create a spreadsheet of the data.

Display in Browser

This will display the report based on the specified criteria. In the example below you will notice it does not include the audit fields, nor is it subtotalling any results.

Extdbrep rep.png

At the bottom of the report you will find the blue folder icon Icon bluefolder.PNG to access the Blue Folder Lookup for export options and mapping (not available for Club, Clinics or Groups reporting.

Export to spreadsheet

This will produce spreadsheet of the data based on the report criteria entered. You can now perform additional data analysis such as a Pivot Table using this raw data.

Extdbrep export.png