Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).

In this article we cover the steps using the use the Join() aggregate function to concatenate all values based on a specific condition. The function will concatenate values into a single string separated by the specified separator (if you do not specify a separator, the function defaults to a comma).

The Join() function uses the following syntax:

[Collection][Condition].Join(Expression)
[Collection][Condition].Join(Expression, Separator)

The following expression concatenates "Disposition" field values within a report grouped by the "Client" field into a single string separated by a comma:

[][[Client] == [^.Client]].Join([Disposition], ',')

Video Tutorial: 

Not Yet Available

Steps to Use Join Aggregates.

OPTIONAL: Download the sample view to follow along with the guide.

1. Open and run your View.

2. Go into the Finished Report Designer.

3. Select the Label you want to have the list summary in. In this example we use the GroupHeader for our summary label.

4. Click the Label Tasks button for the label you selected (located to the right of the label).

5. Then open the Expression Editor.

6. Enter your Join Aggregate function for the desired group level.

Example Used: [][[Client] == [^.Client]].Join([Disposition], ',')

7. Preview your report and see if it gets the desired results. If not, make any needed adjustments to your report.

OPTIONAL: Download the sample view to follow along with the guide.