This may by obtained by creating a custom report in Crystal Reports.  For more information on creating Crystal Reports with Patron Edge, refer to The Patron Edge Crystal Report Runtime Viewer Guide (PDF).

We also offer customized Crystal Report templates. To learn more about our Custom Report Solutions, contact your account manager.


Order type details are stored in the Order table in SQL

SELECT
    DISTINCT(O.ordEMail),
    O.ordField1,
    O.ordFirstName,
    O.ordLastName
FROM
    ORDERS O

Disclaimer: Blackbaud provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Structured Query Language and the tools used to create and modify SQL statements and Crystal Reports. Blackbaud Customer Support may help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality.