Crystal Reports CRM 4.0/Crystal 2008 If Then Selection

Message

   We use Microsoft Dynamics CRM 4.0 on SQL and Crystal 2008.  The CRM database shows numbers in the picklist fields instead of the text and displays the numbers in the report.  For instance, Amy is 1, Paul is 5, Trish is 8.  I have used the Formula Expert to transpose the numbers to text but although I get no errors, the values will not change in the report. An example follows 

if {Opportunity.New_SalesPerson}= 1
then "Amy" else 
if {Opportunity.New_SalesPerson}= 2
then "Bill G" else 
if {Opportunity.New_SalesPerson}= 3
then "Mitch R" else 
if {Opportunity.New_SalesPerson}= 4
then "Neil E" else 
if {Opportunity.New_SalesPerson}= 5
then "Paul" else 
if {Opportunity.New_SalesPerson}= 6
then "Paula J" else 
if {Opportunity.New_SalesPerson}= 7
then "Steve Y" else 
if {Opportunity.New_SalesPerson}= 8
then "Trish" 
else "N/A"

Any thoughts?  If I place " " around the number I get an error "A number is requested here".  Thank you.

Edited by nicim - 31 Aug 2010 at 9:55am