How to Create a Group Fax Report

1.  From SAMS, open Crystal Reports.

2.  Open the report titled grpemail.  (This report is located in Q:\dapps\memb\reports\grpemail.rpt)

3.  Click on the DATA SELECTION EXPERT .

4.  Click on Show Formula.

5.  Click on the Formula Editor button.

6.  In the bottom field of the Formula Editor, highlight {INDV.EMAIL}.  Be sure to include the brackets when you highlight this.  

7.  In the upper left hand column of the Formula Editor, click on the + next to the database.

8.  Click on the +  next to INDV.  This will expand the files.

9.  Scroll down to FAX.

10. Double Click on FAX.  This will replace the highlighted {INDV.EMAIL} with {INDV.FAX}.

11. Close out of the screen.

12. Click OK.

IMPORTANT!! DO NOT ADD ANY ADDITIONAL FIELDS TO THE REPORT!! (ID must be the ONLY FIELD in the report!)

13. Run the report by clicking the Print Preview button.

14. Export the Data.  (It is recommended you do a SAVE AS and save the report as GRPFAX in Q:\dapps\memb\data\out.)

15. Close Crystal Report Writer.  When it asks you if you want to save changes to grpemail, click no.

16. Close the Report Selection Screen in SAMS.