string concatenation

[croger1]

Using Crystal Reports 8:

I have a column of allergy names, one person may have 0 to n allergies. I would like to display them as: allergy1, allergy2, allergy3, etc. to save on vertical space on the worksheets.

I can get only 2 to display correctly using a formula with the next() function.

Can I do this?

 

[kenhamady]

Depending on how many you have you could try:

Summarizing the field with the NthSMallest operation. Create one for smallest, 2nd Smallest, 3rd Smallest, etc. As many as you are likely to have. Then concatenate these together.

Or, you could use multiple columns on the detail section

There is also a running total technique that appends each value to a string variable. It would work like the 3 formula technique described in the FAQ on running totals in the general forum. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[FoxG]

Hi,

I have a sample CR7 report that does this.

What is you email?

Geoff

 

[croger1]

Thanks Geoff, use croger33@yahoo.com for the sample report.

 

[FoxG]

Email sent

 

[croger1]

Thanks to Geoff and ken for the help. I went with the column solution for now, and am trying to adapt Geoff's to my use, I have trouble getting an accurate count of my data. Thanks.