Originally written by John Hardwick, last updated Apr 29, 2026, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
The report is designed to produce a listing of customer’s names and addresses in a format able to be loaded into a mail merge type routine. Filters on the report allow the list to be limited to purchases from specific suppliers / ranges within a date range, and to filter by mail preference.
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 Purchases Mail Shot 17
Customer Only Format
See image above
Customer & Sales Format
This output may produce several lines for a single customer.
The report uses the ‘Tax Inclusive’ setting held against the selling location to show tax inclusive or exclusive selling prices.
Selection Criteria
Run time choices, user selectable.
-
Date Range
Enquiry Customer is the group assigned to all customers who have not purchased within FRS
These customers will not have order details in the data extract.
-
Supplier / Vendor
-
Range / Collection
Use the * character as a wildcard when selecting the range. For example, A* reports on all ranges beginning with A.
Leave set to * to ignore this field
-
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
-
-
Include Header Row
-
Yes / No
-
-
Restricted Location(s) - Sales Location
Print Sequence
As indicated by blue numbered squares in the report example.
1 Customer ID
2 Sales Order Number (Customer & Sales Format Only)
Report Totals
As indicated by yellow numbered squares in the report example.
-
There are none.
Printed Fields
Fields printed on the report.
-
Customer
-
Title
-
Initials
-
Surname
-
Address lines 1 to 5
-
Postcode (Zipcode / Eire Code)
-
Main Telephone
-
Mobile / Cell Phone
-
Daytime Phone Number
-
Email Address
-
Customer ID
-
-
Customer Types (1 to 6)
-
Sales Order Location
When processing in Sales & Orders format (and for none Enquiry Customers), additional column are
-
Sales Order Number
-
Quantity Purchased
-
SKU
-
Model Number
-
Product Description
-
Range / Collection (debranded, where applicable)
-
Supplier / Vendor (debranded, where applicable)
This Report will show the debranded catalogue supplier or the debranded supplier name, dependent upon control settings (RPT_SHOW_CAT_SUP Application parameter)
-
Product Group
-
Sales Order Date
-
Source of Business
-
Sales Order Value
-
Primary Salesperson
-
Secondary Salesperson
-
Line Level Salesperson
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