string formula 1

[Alcar]

I'm fairly new to Crystal Reports.
This is the scenario:
- Crystal Reports for VS.NET

I have a report field composed as string:
", item1, item2, item3"

I need to use a formula to make this field appear like this in the report

Field1
item1
item2
item3

Field2
item1
item2

this is the formula I thought worked, but it's giving me an error:

{ReportExceptions;1.Exception} = Split (Right ({ReportExceptions;1.Exception},Length ({ReportExceptions;1.Exception})-1),",&quot

the error is this:
Error in formula <Record_Selection>. '{ReportExceptions;1.Exception} = Split (Right ({ReportExceptions;1.Exception},Length ({ReportExceptions;1.Exception})-1),',' )' A string is required here.

have no idea can somebody help me please?

 

[synapsevampire]

Try this:

replace(join(split(mid(&quot;, item1, item2, item3&quot;,3)),chr(13)), &quot;,&quot;,&quot;&quot

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Alcar]

worked great. Just needed to change it a little since my items where actually compose by more than one word =)

Thanks!

 

[synapsevampire]

Good, glad it worked. Remember that this has a 254 char limit (all formulas do), otherwise it should be fine.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com