Alright, I had never used crystal reports prior to two days ago and I have been trying to do something that I believe to be nearly impossible, but I would like some more opinions on it.

Our database is filled with product numbers that contain a "-L" or "-S" on the end, for "Large" or "Small" sizes, respectively. We have four different possible sizes: Small, Medium, Large, and X-Large. Each different size has a different UPC code. What we are trying to do is to remove the "-L" from the end of all product numbers, and concatenate the UPC codes with ", " as a delimiter.

We already have a function titled @Model to take the "-L" part off of the name, and I have made a formula using the Next() function to test and concatenate the UPCs, but as I have read everywhere, Crystal Reports can only access one record ahead or behind the current record being processed. I also attempted a recursive approach(I have experience with programming) and Crystal reports does not support that either.

Here is an example of what is going on, it has model numbers like this-

D101MN-L 84564789456 Large

D101MN-S 84564789455 Small

D101MN-X 84564789454 X-Large

D101MN-M 84564789457 Medium

C296KN-L 84651325896 Large

And what I want to make is this-

D101MN 84564789456, 84564789455, 84564789454, 84564789457 Large, Small, X-Large, Medium

C296KN 84651325896 Large

This may be super difficult, again I'm not sure since I had never used this software before Monday.

Correct, Its not going to change the data in the SQL db, but simply edit and concatenate the information given from the database to go on the report differently.