Customer Type Export

Created by Migration Bot, Modified on Fri, 23 Oct at 11:26 AM by Migration Bot

Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).

Part of: Sales Reports


This report is designed to allow the retailer to produce a data export of their customer file.

The output of this report is designed to feed into other systems and therefore may not display accurately within the browser

Crystal Report name Customer Type Export 2.

Selection Criteria

Run time choices, user selectable.

  • Show Separate Title, Initials and Surname

    • Yes / No

  • Restricted Location(s) - Sales Location

Customers without sales orders are available via the ‘No Sales order’ location.

  • Include Header Row

    • Yes / No

  • Include Customers with Mail Flag set

    • Yes / No

  • Include Customers with Email Flag set

    • Yes / No

  • Include Customers with Accept Phone Calls Flag set

    • Yes / No

  • Customer Type(s) - levels 1 to 6

Customers without customer type are collated within the ‘Not set’ group.

  • Group by

    • Customer / Location within Customer

Print Sequence

As indicated by blue numbered squares in the report example.

1 Customer Number

2 Sales Location (where chosen)

Report Totals

As indicated by yellow numbered squares in the report example.

  • There are none.

Printed Fields

Fields printed on the report.

  • Customer

    • ID

    • Title

    • Initials

    • Surname (or Title, Initials and Surname printed as a single field if selected)

    • Address lines 1 to 5

    • Postcode (zip code / Eircode)

    • Last Location to take an Order

    • Main Telephone

    • Daytime Phone Number

    • Mobile / Cell Phone

    • Email Address

  • Email Marketing Preference

  • Postal Marketing Preference

  • Phone Call Marketing Preference

  • Customer Types (1 to 6)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article