Multiple rows into 1 row...

[oshlonger]

I have a parameter that can be multiple values. If I use the following formula, I can list the parameters separated by a comma:
join({?Product}, ", &quot

My issue is this - I have multiple companies associated with an Product Id (one to many relationship). I'm trying to get the Product Id to list once and all the companies to be separated by a comma. Can this be done?

This is what I get:
ID Company
--------------------
11 IBM
11 GE Capital
11 Honeywell

I want this:
ID Company
---------------------
11 IBM, GE Capital, Honeywell


Any info would be appreciated!

 

[kenhamady]

see faq149-243 for a list of sample formulas. One of them shows you how to do this. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[oshlonger]

Thanks, I found the formula I needed!

 

[oshlonger]

Ken,
How would I go about creating a second set of formulas that picks up where this one leaves off?

 

[kenhamady]

You would need another similar set of formulas, but you would have to control the accumulation so that it didn't start appending to the varialbe until the first one hit the limit.

I have never had reason to work out the details, but I am sure it can be done. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com