variable formula

[catchingup]

i am trying to create a formula in CR 11 that will list the number of IDcode(s). There may be 1 or more codes and I wanted them to print in a row (code1, code2, code 3, etc)

The way i have it set up right now, it is printing:
Code1
Code2
Code3

I was told that i should be able to get it to print in a row if I use a variable formula but am not certain how to go about that. The code I am pulling now is part of a larger grouping of numbers so I am using the formula:
@IDCode = {Code.Fullcode} [4 to 8]

Any suggestions?

 

[lbass]

Create three formulas:

//{@reset} to be placed in the group header:
whileprintingrecords;
stringvar code;
if not inrepeatedgroupheader then
code := 0;

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar code := code + {Code.Fullcode}[4 to 8]+", ";

//{@displ} to be placed in the group footer:
whileprintingrecords;
stringvar code;
if len(code) >= 2 then
left(code,len(code)-2);

This assumes that the code is a string. If it isn't, then wrap the code field in totext(), as in:

totext({Code.Fullcode}[4 to 8],0,"")

-LB