Splitting csv field to separate detail rows 1

[amoeba102]

I have a field that may have from 0 to 12 comma separated values. I need to display each value on a separate detail row. Using CR9. I tried creating a view, but failed terribly. This is against a SQL Server database which I have never used before. I'm used to Oracle.

 

[bdreed35]

Try creating the following formula and place it in your detail section:

join(split({table.field},","),chr(13));

Right click the field once it is on the report, and choose Format field.
Under Common tab, choose Can Grow.

The formula will split the field into an array using the comma as a delimter. It then joins each element of the array back together using a new line character (chr(13)). The Can Grow will allow for the field to expand to the size it needs to be.

~Brian

 

[amoeba102]

Wow, so simple. And it works perfectly. Thanks