How to Get a Customer Address Report Grouped by City

How to Get a Customer Address Report Grouped by City

The universal report is a powerful tool. It has lots of options and to learn how to use it, it's best to use a real life example. 
  1. Navigation: Reports → Accounting → Universal Report
  2. In the first dropdown, choose Catalog.
  3. In the second drop down, choose Addresses / Contact.
  4. Click Settings.
  5. Click the Indicators tab and uncheck fields you don’t need.
  6. To create filter to show only customers. click the Filters tab
  7. Click Add.
  8. Expand Owner.
  9. Choose the Customer field.
  10. In the comparison type field choose Equals to.
  11. In the value field, choose Yes.
  12. To get the customers grouped by city, click the Grouping tab,
  13. Click Add.
  14. Choose City from the list of fields.

    • Related Articles

    • How to create a Customer List using the Universal Report

      Resolution is :       1. Go to Reports → Universal Report.       2. Select Catalog and Address/Contact.       3. Click Show Settings, Grouping by "Owner"       4. Click Run Report. This will show all address/contacts from all customer cards grouped ...

    • Open Sales Orders by Item Report

      How can I run a report that shows all of my open orders with back-ordered item information? Open Sales Orders by Item Report The Open Sales Order by Item report will list all Open Sales Orders, grouped by Item. There are columns that show shipped, ...

    • Assembly Bill of Materials Report

      Overview If you have ever wanted to see a quick look at what assemblies a product is used in, this report will do the trick.   Complete the steps below once and save,  and you can run the report whenever you need it.   The report will be grouped by ...

    • How to create a customized report displaying Sales Invoices by a customer?

      Resolution Steps: 1. Click on Reports module. 2. Click on Universal Reports. 3. Select "Document", "Sales Invoice" respectively. 4. Click Show Settings. 5. In Filters tab select two Fields as "Company" and "Posted", Comparison type as "Equal to" and ...

    • Do I have to set the settings every time I run the Universal Report?

      When creating a Universal Report, you may save the settings so that you don't have to change them again the next time you need to run that report. After you have selected the groupings, filters, indicators and conditional appearance settings, click ...