Combine multiple string records in one string

[nina1]

I use Crystal reports version 10 and Betriave database.
I am exporting invoices with multiple line items and my problem is with the description field.
The data look like this:
Invoice# item# Description Qty
3888 Order#4555 0
3888 BOL#000055 0
3888 PacKL:3888 0
3888 443V Bolt 50
3888 EX Part 0
3888 Order#4556 0
3888 BOL#000056 0
3888 PacKL:3888 0
3888 444D Bolt 75
3888 EX Part 0
I want to combine the Description field in on field .
I use this report to import it to MS Acces database table.
Any help would be appreciated

Thanks

 

[Madawc]

Do you mean, you want to string together all of the descriptions for the invoice? I did something similar for postcodes, which you should be able to adapt:

// 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