just one little addition...lets assume your picklist is called
if you drop this field onto your report you will see just a number which is
its id from the stringmap table.
if you look at the fields again in crystal you will see an addition called
cfpjohnspicklistname....this is the one that contains the actual text
Microsoft CRM MVP