Can a string be created from a recordset?

[Guest_imported]

There is a stored procedure that returns a variable number of records. Is there a way to create a formula that creates one string for all the records in Crystal Reports? In VB its just a matter of looping through the recordset and adding each record to the string. How would you do this in Crystal Reports?

 

[kenhamady]

You need a running total of string values, that appends one to a variable on each record.

See the FAQ on running totals in the general forum. Use the 3-formula technique. However you will use a StringVAr instread of a NumberVar. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/