How to Create an All Client Addresses Report in G5

How to Create an All Client Addresses Report in G5

An All Client Addresses report will list each address of each Client Household in your database.

  Note:

  • Once you have created this report, you can export it.
  • Before you export it, go to the settings tab and select the export setting Collapse to a single row using a delimiter.
  • This will ensure that each Household has one line on the spreadsheet, and that line will have each of their addresses in turn.

To create this report:

  1. Go to the Report workspace.
  2. Click Add Report.
  3. Select Households. Click Blank Households Report to open the report creation screen.
  4. Name the report All Client Addresses.
  5. In the Details Tab, add Full Name, Address>Address 1, Address>Address 2, Address>City, Address>Province/State, and Address>Postal Code/Zip, in the Fields section.
  6. Add Status equals Client to the Filters section of the report.
  7. Select Full Name in the Sorting section.
  8. Set the View and edit permissions to Public. Click Save when finished.

    • Related Articles

    • How to Create an All Client Emails Report in G5

      An All Client Emails Report will list each email of each Client Household in your database. Note: Once you have created this report, you can export it. Before you export it, go to the settings tab and select the export setting Collapse to a single ...
    • How to Create an All Client Phone Numbers Report in G5

      An All Client Phone Numbers Report will list each phone number of each Client Household in your database. Note: Once you have created this report, you can export it. Before you export it, go to the settings tab and select the export setting Collapse ...
    • Managing addresses

      You can manage addresses by going to the Addresses Card on their Detail tab. When adding addresses you can provide address types. These describe the address's relationship to the person, like work, home, etc. You can add addresses for an entity as ...
    • How to Create Client Coverage Groups

      Your Client Coverage Group(s) will determine who has access to view the clients, prospects, and other Contact Groups that are assigned to that Coverage Group(s). To Create Your Client Coverage Group(s): Click on the Customize menu in G5. Select the ...
    • Detail Report

      The Detail report contains the following information for one or more Contact Groups: First and last names for contacts or company names for Contact Groups. Information about the Contact Group that is contained in the Contact Group record. For ...