How do I put field data into a string?

[Ajit2]

Hi, hopefully some knows how to do this. When I run a report and the report is populated with data, I want to take some of the information in the details columns and put in a string. Can I do this using a formula? Any ideas how?

Clarification:

I have run the report and the details section has some columns:

NAME OTHERINFO
name1 OtherInfo1
name2 OtherInfo2
name3 OtherInfo3 ... (so on)

How do I get a string so that the string = 'name1, name2, name3'?

 

[synapsevampire]

You can concatenate them into a string, but generally this is done within a group level:

whileprintingrecords;
stringvar AllNames:=AllNames + {table.name} +", ";
""

Then in the report footer place:

whileprintingrecords;
stringvar AllNames:=AllNames + {table.name} +", ";
left(AllNames,len(Allnames)-2)

-k

 

[Ajit2]

Thanks, that was very helpful!