Values from PickLists on Reports

Values from PickLists on Reports

Post by Paul McBri » Wed, 29 Sep 2004 03:05:40


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?
 
 
 

Values from PickLists on Reports

Post by kat » Wed, 29 Sep 2004 03:12:21

Picklist values are stored in the stringmap table.
create a custom report,
when I look in the
(which, of course,
value, and not the

 
 
 

Values from PickLists on Reports

Post by John O'Don » Wed, 29 Sep 2004 12:05:32

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.yqcomputer.com/
 
 
 

Values from PickLists on Reports

Post by Paul McBri » Wed, 29 Sep 2004 22:19:38

Thank you both.

"John O'Donnell" < XXXX@XXXXX.COM > wrote in

is