Difference between revisions of "Change of Address Report"

From Charitylog Manual
Jump to: navigation, search
Line 3: Line 3:
 
[[File:coa1.jpg|500px|alt="a screenshot of the change of address report button, highlighted in the admin menu."]]
 
[[File:coa1.jpg|500px|alt="a screenshot of the change of address report button, highlighted in the admin menu."]]
  
This report allows you to report on changes of addresses.
+
This report is a quick way to discover which records have had a change of address or phone number within a certain time period.
  
[[File:coa2.jpg|700px|alt="a screenshot of the change of address report data entry page."]]
+
[[File[[File::coa2.jpg]]|700px|alt="a screenshot of the change of address report data entry page."]]
  
 
Complete the following:
 
Complete the following:
* '''Address changed on or since''' - The start date of the period to be reported on, this will include changes on the date entered.
+
* '''Address changed between''' - The date range you would like to see any address changes between.
* '''Address changed on or before''' - The end date of the period to be reported on, this will include changes on the date entered.
+
* '''Organisation/Person Type''' - The type of record you would like to see change of address information about. I.e. Service User
* '''Organisation / Person type''' - Select the organisation or people that you wish to include. Use the CTRL key on the keyboard to select multiple.
+
* '''Filter by Surname''' - This filter can be used to find a specific user record.
* '''Filter by surname''' - Enter details here to use as a search filter from the Surname\Name field of the record.
+
* '''Include telephone number changes''' - Filter by any records that have changed their telephone number in the date period selected.
* '''Filter by Other Names''' - Enter details here to use as a search filter from the Forenames field of the record.
 
* '''Include telephone number changes''' - Select this if you wish to include changes to telephone numbers in addition to changes of address.
 
  
If you are on a [[Modules| Branch System]] use the Branch Reporting tab to select the required branches.
+
If you are on a [[Modules| Branch System]] you can select whether you want to use all branches to search or a specific branch (you must have permission to access the branch first before you can use it to run the report.)
  
To run the report click on the 'Display in Browser' button, from here you will be able to print the report or access the [[Blue Folder Lookup]] tool.
+
To run the report click on the 'Display in Browser' button, from here you will be able to print, export the report or access the [[Blue Folder Lookup]] tool.
 
 
To export the results directly to a spreadsheet click on the 'Export to Spreadsheet' button.
 
  
 +
To export the results directly to a spreadsheet without using the [[Blue Folder Lookup]] click on the 'Export to Spreadsheet' button.
  
 
----
 
----
 
[[File:helpheader_small.png|right]]
 
[[File:helpheader_small.png|right]]

Revision as of 15:42, 31 December 2024

Helpheader small.png

500px

This report is a quick way to discover which records have had a change of address or phone number within a certain time period.

[[File[[File::coa2.jpg]]|700px|alt="a screenshot of the change of address report data entry page."]]

Complete the following:

  • Address changed between - The date range you would like to see any address changes between.
  • Organisation/Person Type - The type of record you would like to see change of address information about. I.e. Service User
  • Filter by Surname - This filter can be used to find a specific user record.
  • Include telephone number changes - Filter by any records that have changed their telephone number in the date period selected.

If you are on a Branch System you can select whether you want to use all branches to search or a specific branch (you must have permission to access the branch first before you can use it to run the report.)

To run the report click on the 'Display in Browser' button, from here you will be able to print, export the report or access the Blue Folder Lookup tool.

To export the results directly to a spreadsheet without using the Blue Folder Lookup click on the 'Export to Spreadsheet' button.


Helpheader small.png