Customer Base Data Export (1214 onwards)

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

Originally written by John Hardwick, last updated Apr 29, 2026, on the Swan Retail knowledge base (FRS).

Part of: Financial Reports


This report is designed to allow the retailer to produce a data export of their customer file containing most fields displayed when viewing the customer’s details within Find Customer.

image-20250616-145539.png

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 Base Data Export 1

Selection Criteria

Run time choices, user selectable.

  • Email Marketing Preference

    • Accept / Reject / Ignore Filter

  • Postal Marketing Preference

    • Accept / Reject / Ignore Filter

  • Telephone Marketing Preference

    • Accept / Reject / Ignore Filter

  • Customer Filter

    • Enquirers Only / Customers with Order Histories / Ignore Filter

Print Sequence

As indicated by blue numbered squares in the report example.

  • Not Applicable.

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

    • Middle Initials

    • Initials

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

    • Suffix

    • Telephone

    • Daytime Telephone

    • Mobile (cell)

    • Email Address

    • Instructions

    • Marketing Email Preference

    • Postal Marketing Preference

    • Telephone Marketing Preference

    • Last Contact Date

    • Last Purchase Date

    • Comments

    • Date Created

    • Active Indicator

    • Telephone Narrative

    • Daytime Telephone Narrative

    • Mobile Narrative

    • Master Address

      • House Number

      • Flat Number

      • Address lines 1 to 5

      • Postcode (zipcode / Eirecode)

    • Invoice to Address

      • House Number

      • Flat Number

      • Address lines 1 to 5

      • Postcode (zipcode / Eirecode)

    • Deliver To Address

      • House Number

      • Flat Number

      • Address lines 1 to 5

      • Postcode (zipcode / Eirecode)

    • Sales Order Count

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