String Array formula Crystal Reports v10

[golfnut64]

I have a field and I want to string the data see example below

CONSOL_NUMB CUST_PO
1000738 64905400
1000738 64905380

I want the string to be like example below

CONSOL_NUMB CUST_PO
1000738 64905400,64905380

I keep getting a string array should be used here but I don't know how to use it please help.

 

[Madawc]

You don't need an array. Group by CONSOL_NUMB. Suppress the details. Collect the codes.

I did something similar for postcodes: you should be able to adapt it.

Accumulate postcodes for groups
// Accumulate using a formula field (suppressed) in the detail line.  Allow for nulls and blanks.
whileprintingrecords;
if not isnull({Recc.Postcode}) and {Recc.Postcode} <> " "
then stringvar pst := pst + {Recc.Postcode} +", "
else if length(pst) = 0 
then stringvar pst := pst + "Excluding blanks; "
else stringvar pst := pst 

// Show in using a formula field in the group footer.
whileprintingrecords;
stringvar pst;
left(pst,len(pst)-2)

//  Clear using a formula field using in the group header.
whileprintingrecords;
stringvar pst := "";

Note that clearing in the footer avoids problems with group headers repeating on a new page, which does clear everything for the group. Provided the 'clear' is placed in the section AFTER the display, it will do them in that order.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[synapsevampire]

I'd adjust this slightly and add in the ability to dedupe and other minor differences:

Group Header formula (suppress this section):
whileprintingrecords;
stringvar pst:="";

Details Formula (suppress this section):
whileprintingrecords;
stringvar pst;
if not isnull({Recc.Postcode}) and trim({Recc.Postcode})<> ""
and
not({Recc.Postcode} in pst) then
pst:=pst & {Recc.Postcode} & ", "

Group Footer formula (where everything is displayed):
whileprintingrecords;
stringvar pst;
left(pst,len(pst)-1)

We could also have used an array.

-k