I have a picklist for my accounts screen. I want to create a custom report,
and have it be sortable by the picklist "name". However, when I look in the
AccountBase table, only the value is stored in the table (which, of course,
makes perfect sense.). How do I access the descriptive value, and not the
numeric one, for my report?

Picklist values are stored in the stringmap table.

just one little addition...lets assume your picklist is called
cfpjohnspicklist.
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

--
John O'Donnell
Microsoft CRM MVP
http://www.microsoft.com/BusinessSol...aqLanding.aspx


"kat" <anonymous@discussions.microsoft.com> wrote in message
news:22da01c4a4bd$880527f0$a501280a@phx.gbl...

Thank you both.

"John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in
message news:u3xGKgQpEHA.2032@TK2MSFTNGP10.phx.gbl...