Field Separation

[CNeeds]

I have a field with multi-values into Crystal V9. I want it to appear a multiple line field. I have a couple that already fields doing this like I want just fine. But this one field isn't doing it and I cannot figure out why.

01;02;03

I want:
01
02
03

Any suggestion why this field is giving trouble...Any way to manually force the format into fields.

Thanks!!!

 

[dgillz]

so is the field value literally the string "01;02;03"? If so what is the maximum number of values in the field?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[vidru]

Try a formula like this:

Replace({YourField},";",chr(13));

Then place the formula field on the report, and check the 'Can Grow' option.

-dave

 

[lbass]

You could also use:

split({table.field},";")[1]

Create two other formulas by changing the "1" to "2" or "3" to return the other values. You could then use these values independently of each other if needed.

-LB