A client wants to include the email address of the salesperson in a Crystal Report, in Group Header 1 (which changes for a salesperson).

However, the AR salesperson table only includes one text field - salesperson name, and it's only 30 characters, which is inadequate.

I know there has to be a CR formula I could use to choose from a list, and build it into the report, but that has two disadvantages - 1) someone has to maintain the list and 2) it will apply only to the one report.

Short of getting Softrak to add an email address field to the salesperson table, is there another approach I could use in the meantime?

Thanks

Steve

PS - I found the formula - it's the "Switch" formula, but that formula is not a version 7 function, so the report must be hung off of Ledger or BankRec, which launch version 8.5 of CR.