Report list of values as a comma seperated list of values

English Forum
2

You can use a combination of the following:

  • add a report container item (as you probably already have)
  • add a footer that reads Join$(<YourField>, ", ")
  • set “Suppress Data Lines” to Yes

That does the trick - the Join$ aggregate function results in the required comma separated list, the report container makes sure that the values are iterated and finally the suppression takes care to only print the aggregated values. I attach a sample for our demo application that aggregates the category names in this way:

image

JoinAggregateDemo.srt (22.6 KB)