Horizontal details 1

[Futang44]

I am trying to list names horizontally,
example, instead of:
bob
fred
bill
ned
I want :
bob, fred, bill, ned, etc.

Does anyone know how?
I will be using just one table.

 

[solmskid]

Futang44

In the Section Expert, for the Detail Section is an option
to use "Multiple Columns". Check it out.

solmskid

 

[Futang44]

Is there a way to set a variable width between the columns so the field may be concatenated?

 

[solmskid]

Futang44

I have not used the option that much to give you a valid answer. But what I would do if you have to concatenate fields (first name, last name) is create a formula that does the concatenation and use the formula in the detail.

solmskid

 

[Futang44]

what I am attempting to do is concatenate the same field for multiple records.

 

[ianoctdec]

Hello,

Create three formulas:
@ConacatenateFields
stringvar vList := vList + table.field + ', '

Place it in the details, suppress it.

@DisplayList
stringvar vList;
left(vList, len(vList)-2)

Place it in the group footer

@ResetList
stringvar vList := ''

Place it in the group header.

Daniela

 

[solmskid]

when you are in the Section Expert and select the multiple column option it adds a "layout" tab which allows you to customize the format.

 

[ianoctdec]

I forgot a detail: each formula needs to have start with the line whileprintingrecords:

@ConacatenateFields
whileprintingrecords;
stringvar vList := vList + table.field + ', '

Place it in the details, suppress it.

@DisplayList
whileprintingrecords;
stringvar vList;
left(vList, len(vList)-2)

Place it in the group footer

@ResetList
whileprintingrecords;
stringvar vList := ''

Place it in the group header