---
title: "Advanced Report Coding (Using Owners, Divisions & Assignees in a Report)"
description: "This article shows you how to show fields with several values, such as Owners, Divisions and Assignees, in one cell of a report. > **Applies to:** System administrators (`admin` role) · **Module:** Set up > Reports ## Why These Fields…"
url: "https://support.symbiant.co.uk/kb/advanced-report-coding/"
updated: "2026-10-30"
category: Reporting Suite Tutorial
tags:
  - Add
  - Excel
  - Reports
  - Spreadsheets
  - Updating
  - Word
---

# Advanced Report Coding (Using Owners, Divisions & Assignees in a Report)

This article shows you how to show fields with several values, such as Owners, Divisions and Assignees, in one cell of a report.

> **Applies to:** System administrators (`admin` role) · **Module:** Set up > Reports

## Why These Fields Need Extra Code

A plain marker such as `{{data:risk/reference}}` works for single values. Owners, Divisions and Assignees can hold several values, so the marker must say which part of each value to show (**fold**) and how to separate them (**join**).

## The fold Function

Add `|fold(...)` after the field key:

- Owners and assignees: `fold(name)` or `fold(email)`.
- Divisions: `fold(path)` for the full path (for example Company/UK/IT) or `fold(name)` for the last part only (IT).

## The join Function

Wrap the marker and add `:join(...)` with the separator to put between values, for example `:join(, )` or `:join(; )`.

Putting it together, from the shipped **Risk Register (Basic)** template:

- `{{data:generic/divisions|fold(path)}:join(; )}`
- `{{data:generic/owners|fold(name)}:join(, )}`

![fold and join in an Excel template](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-fold-template-320c66.png)

## The Output

Each cell shows all the values with your separator, for example `Admin Account` or `Company/UK/Operations`. With two owners it would read `Owner One, Owner Two`.

![The values in the generated report](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-fold-output-af5fc8.png)

## Related articles

- [Advanced Report Syntax](https://support.symbiant.co.uk/kb/advanced-report-syntax/)
- [Creating an Excel Report (Basic Data Output)](https://support.symbiant.co.uk/kb/basic-excel-report/)
