joining fields to make a single field

[americvish]

i have a requirement where i should join the resulting fields into one field. that is i have region field.

region
------
east
west
north
south

i want to present it in this way

Region
-------
east, west, north, south


can somebody pls help me out.
thanks.

 

[jlopeman]

Please provide a little more information or context to this request to better be able to help you.

 

[americvish]

i am getting the data results in 4 rows in detail section of the report as below:

region
------
east
west
north
south

and i want to present join them to make it a single row like

region
------
east, west, north, south


when i use join it says it need a array where as the region field is string from database.

i am not able to come up with above presentation.
needed a help on it.

 

[MCuthill]

Depending on your version of Crystal Reports...

In Crystal X (for sure): Selection Expert >> Check the "Format With Multiple Columns" box.
(Assumining this is all that is in your details row.

If this will not suffice, see this post: thread767-1655530


Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."