One Line Output from Multiple Records 1

[ldalessio]

Good Morning All.
I am having brain freeze this morning. I need to read multiple customer records and output a field from each records on one line.

TABLE:
Customer Id
Slot Designation (multiple for each customer)

IE:
John Jones
ADMPRN
John Jones
DEDCT
John Jones
EXTCUR

I need the output to be:
John Jones ADMPRN DEDCT EXTCUR

Can you help an old lady out?
Many Thanks.

 

[lbass]

I'm guessing you have put these two fields in different detail sections? Anyway, first insert a group on {table.customerID} and then create a set of formulas like this.

//{@reset} to be placed in the customer group header and suppressed:
whileprintingrecords;
stringvar slotdes;
if not inrepeatedgroupheader then
slotdes := "";

//{@accum} to be placed in the detail section and suppressed:
whileprintingrecords;
stringvar slotdes := slotdes + {table.slotdesignation} + " ";

//{@display} to be placed in the group footer:
whileprintingrecords;
stringvar slotdes;

Drag the groupname into the group footer, place {@display} next to it, and suppress the group header and detail sections.

-LB

 

[ldalessio]

Thank You Thank You Thank You.
I had most of the calcs right but just learned a new one.
I wasn't aware of the "inrepeatedgroupheader".