I would use the Split() function to put the numbers into an array and then use the Choose() function to assign text to the string based upon the number. Here is a test function I wrote. Replace the test fields with your report fields and change the text in the Choose() function accordingly.

StringVar YourField;
StringVar Array ValueArray;
NumberVar ArrayIndex;
StringVar YourDescription;
YourField := "1,3,5";
//Trim that trailing comma because it adds an unnecssary extra element
YourField := Mid(YourField, 1, Len(YourField)-1);
ValueArray := Split(YourField,",");
For ArrayIndex:= 1 to UBound(ValueArray) Do
(
    YourDescription := YourDescription + Choose(Val(ValueArray[ArrayIndex]), "field1", "field2", "field3", "field 4", "field5") + ",";
);
//Trim the trailing comma
YourDescription := Mid(YourDescription, 1, Len(YourDescription)-1);

You can find out about these formulas and all the other Crystal Reports functions in Chapter 7, Writing Formulas, of my book Crystal Reports Encyclopedia.




Edited by BrianBischof - 28 Jan 2008 at 11:42am