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
Feedback sent
We appreciate your effort and will try to fix the article