Crystal Reports Concatenating records...

Message

   Hi all,

I've managed to create a variable that is a concatenation of a bunch of records, using:

WhilePrintingRecords; 

@BuildRecords // name of formula

stringvar concatRecs; 

if RecordNumber = 1 

then( concatRecs := concatRecs + {table.field}; ) 

else( concatRecs := concatRecs + ", " + {table.field}; ); 

And then printing the results with:

EvaluateAfter({@BuildRecords});

stringvar concatRecs := {@BuildRecords};

concatRecs;

... the only problem is, it prints the variable after every iteration, such that the first line has one record, the second has two, and so on.. I only want to print the last one. Any ideas?

Edited by trentz - 10 Sep 2012 at 9:00pm