---
title: Creating an Advanced Word Report (Adding Functions)
description: "This article builds on [Creating a Word Report](https://support.symbiant.co.uk/kb/basic-word-report/). It shows you how to add repeating tables, hide empty sections and use data source functions. > **Applies to:** System administrators (`admin` role) · **Module:** Set up > Reports ## Before You…"
url: "https://support.symbiant.co.uk/kb/advanced-word-report/"
updated: "2026-10-30"
category: Reporting Suite Tutorial
tags:
  - Add
  - Reports
  - Word
---

# Creating an Advanced Word Report (Adding Functions)

This article builds on [Creating a Word Report](https://support.symbiant.co.uk/kb/basic-word-report/). It shows you how to add repeating tables, hide empty sections and use data source functions.

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

## Before You Start

Set up the report, its graph data source and its fields as in [Creating a Word Report (Basic Data Output)](https://support.symbiant.co.uk/kb/basic-word-report/). Tick the linked data you want to list too, for example **Impact Controls** with their reference and summary.

## Repeating Tables for Linked Records

To list linked records (such as a risk's controls), put a table in the template with one row of markers. That row repeats for each linked record.

1. Above the table, add a heading with a section marker that names the linked data, for example `[[rd:risk.impact/controls]:collapse:hide]`.
2. In the table row, use markers that go through the link, for example `[[rd:risk.impact/controls:risk.control/ref:control/reference]]`.
   ![Repeating tables in the shipped Risk Details template](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-word-template-tables-2e7abf.png)

`:collapse:hide` hides the whole section, heading included, when the record has nothing linked.

## Showing Many Values in One Place

Fields that can hold several values, such as **Owners** and **Divisions**, need `fold` and `join`, for example `[[rd:generic/owners|fold(name)]:join(, )]`. See [Advanced Report Coding](https://support.symbiant.co.uk/kb/advanced-report-coding/).

## Colouring a Cell by Level

The shipped template colours a table cell with the level's colour using `[[rd:risk/level:generic/colour]:merge-xml]`. Tick the level's **colour** in the graph for this to work.

## Data Source Functions

Click **Functions** next to a data source to switch on extra processing, such as **Time Filter**, **Where Filter**, **Sort**, **Format date** and **Group by**. Tick a function, then click its **Configure...** to set it up.

![The Functions list](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-functions-90521f.png)

## Uploading the Template

1. Under **Document template**, click **Choose File** (or drag the file onto **Drop file here**) and pick your template.
   ![Uploading the template](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-doc-template-new-058b91.png)
2. Click **Save** at the top right.
   ![The Save button](https://support.symbiant.co.uk/wp-content/uploads/2026/10/translators-save-f3437f.png)

## Generating the Report

1. Click the **Set up** button at the bottom left to leave Set up.
   ![Leaving Set up](https://support.symbiant.co.uk/wp-content/uploads/2026/10/kb-common-exit-setup-a986db.png)
2. Click **Reports** at the bottom of the menu on the left.
   ![Reports in the main menu](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-front-nav-d62952.png)
3. Find the report (type part of its name in the **Name** filter) and click **Generate**. The file downloads to your computer.
   ![Generate](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-front-generate-372a86.png)

> **Tip:** Click **Filter** next to **Generate** to limit which records go into the report. See [Advanced Filtering on Reports](https://support.symbiant.co.uk/kb/advanced-filtering-on-reports/).

## Related articles

- [Advanced Report Syntax](https://support.symbiant.co.uk/kb/advanced-report-syntax/)
- [Advanced Report Coding](https://support.symbiant.co.uk/kb/advanced-report-coding/)
