---
title: "Reporting on Multi-Valued Fields"
slug: "reporting-on-multi-valued-fields"
updated: 2026-03-25T20:03:02Z
published: 2026-03-25T20:03:02Z
canonical: "knowledge.technolutions.net/reporting-on-multi-valued-fields"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Reporting on Multi-Valued Fields

[Fields that store multiple values from a prompt list](/v1/docs/fields-that-store-multiple-values-from-a-prompt-list), also known as multi-valued fields, allow records to have more than one value in a single field, such as having multiple academic interests for a student in a single field. Given this one-to-many relationship (e.g., one student to their many possible academic interests), you will need to report on this differently than other one-to-one data.

We've detailed the broad steps to build such a report below.

[![mceclip6.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/deb9ecmoukkchgccmjvhzwmceclip6.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/deb9ecmoukkchgccmjvhzwmceclip6.png)

## **Adding the Report Part**

1. Add a new part to your report by clicking on "Data/Charts".
2. Specify a Name, and then select:
  - Type of "Configurable Joins"
  - Category of "Related"
  - Base of "Field Values"
3. Click **Save**.

[![mceclip0.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/bvwakhjgeeay8eownfrxggmceclip0.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/bvwakhjgeeay8eownfrxggmceclip0.png)

## **Adding Filters and Joins to the Report Part**

1. Enter the **Edit Report Parts**view by completing the steps above or [editing an existing part](/v1/docs/creating-editing-and-rendering-reports#edit-report-parts).
2. Add the "ID" filter, entering the field ID for the field you want to report on.
3. To filter on the record itself, you’ll need to make a join based on the scope of the field:
  - Person-scoped, join from "Field Values" to "Person"
  - Application-scoped, join from "Field Values" to "Application"
  - Dataset-scoped, join from "Field Values" to "Dataset Row"

[![mceclip0.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/4gb7c3jzfkqr6bred6zy7amceclip0.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/4gb7c3jzfkqr6bred6zy7amceclip0.png)

## **Configuring Columns**

Next, you will want to [add at least one column](/v1/docs/creating-editing-and-rendering-reports#columns) to your report. In the example above, there is only one column configured. This column has no filters and simply counts all of the field values in each row.

![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Screenshot 2026-03-17 at 10.03.34 AM.png)

However, if you need multiple columns, you will need to make the same record join inside each column in order to target filters and joins on the record base:

![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Screenshot 2026-03-17 at 10.06.13 AM.png)

## **Configuring Rows**

Finally, you can [configure the rows](/v1/docs/creating-editing-and-rendering-reports#rows-and-row-groups) of your report. Since multi-valued fields use prompts, you will need to use the **Prompt Value**export on the Field Values base to see the data in your selected field.

If you want to export additional data about the prompt, join from "Field Values" to "Lookup Prompt". This will allow you to report on attributes about the field, such as their category or export value. The **Value**export on this base will export the same information as the **Prompt Value**export on the Field Values base.

In the example above, the row configuration uses the **Category**and **Value**exports on the Lookup Prompt base to display the type of major and the major itself.

[![mceclip1.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/c3nsgepfmuecbeor8lku5gmceclip1.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/c3nsgepfmuecbeor8lku5gmceclip1.png)