---
title: "Merging Report Fields"
slug: "merging-report-fields"
description: "This document shows how to combine data for two separate sources in one column on a report in Decisions.  The example shows how to accomplish this by using CombineTextFields, or MergeTextInlineField, under the Data Fields column in the Decisions Report Designer. "
updated: 2024-07-17T14:07:20Z
published: 2024-07-17T14:07:20Z
---

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

# Merging Report Fields

## Overview

Combining data from two sources in a Report column can make reports more useful. Merged data can summarize information, assist in analyzing, or provide new insights into Report content. This article will show two ways of merging Report fields.

---

## Using CombineTextFields

1. Under **Data Fields,** select **Add,** then expand the **Calculated Columns**category. Select **CombineTextFields**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-17_09h49_25.png)
2. In the **Add Calculated Column** dialog, the user can select the data to merge. The data to be merged is based on the Data Source in the Report. The user can merge data from any two sources relating to an account.

3. In the **Data > First Field** drop-down list, select **Created By**. Next, select **Created On Date** in the **Data > Second Field** drop-down list. Select OK to save. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-17_09h53_53.png)

4. Notice the **Combine_Text_Fields** column now contains data from the merged fields.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-17_09h57_27.png)

---

## Using MergeTextInlineField

MergeTextInlineField allows for a more dynamic way of merging information using a Merge Text Editor.

1. In the same Report, remove the **Combine_Text_Fields** column.
2. Now add the "MergeTextInlineField" **Calculated Column** to the Report; under **Data Fields,** select **Add,** then expand the **Calculated Columns**category. Select the **MergeTextInlineField**.  
![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-17_09h58_45.png)
3. In the **Add Calculated Column** dialog, select the data to merge.
4. Under **Data > Display Text,** select **Show Editor**.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-17_10h00_53.png)
5. In the Merge Text Editor, type a dynamic statement to show in the Report column. In this example, type: "This account was created by: **[Created By]** on **[Created On Date]**." ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-17_10h04_03.png)
6. Select **Save** to save and close. Then select OK in the **Add Calculated Column** dialog.
7. Notice the **Merge_Text_Inline_Feild** column now contains data from the merged fields.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-07-17_10h06_27.png)