AnsweredAssumed Answered

How to create a report that combines a series of records into a paragraph

Question asked by tcison on Apr 30, 2018
Latest reply on May 3, 2018 by tcison

I have a table with accessories.  Some products come with certain accessories and when trying to communicate that, I'd like to collect all of the accessories to a concatenated paragraph for lack of a better term.

 

For example.  I'd like by description to read like this:

                           Widget One comes with: acc1, acc5, acc7, and acc9.

                           Widget Two comes with: acc2, acc3, acc5, and acc11

 

How do I create, I'm guessing a merge variable, or something... That can merge my accessories into a comma delimited single line.

Outcomes