---
title: "Expanding groups"
description: "Enable expanding to display individual lines instead of a single total."
lang: en
languages:
  en: https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/layout-editor/expanding-groups/index.md
  no: https://docs.vismasoftware.no/no/onestopreporting/create-templates/report-designer/creating-reports/layout-editor/expanding-groups/index.md
lastmod: 2026-07-21
---

> Documentation index: https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/layout-editor/expanding-groups/llms.txt


# Expanding groups

Last modified July 21, 2026

> Enable expanding to display individual lines instead of a single total.

*Expanding groups* are an essential part of the **Report Designer**. It involves, for example, creating a list of each account rather than grouping the accounts together and displaying a total for all accounts.

## Create expanding groups

To create expanding groups;

1. In the **Layout Editor** window, select the **Expanding** checkbox to create expanding groups in the specified row or column for data items that have been set to **Group** in the **Grouping/Sorting** tab.

> [!TIP]
> The quickest way to create an expanding group is by dragging a data item, such as *Sales Person* into the report definition and selecting *Create a new selection group on the Row* or *Create a new selection group on the Column*. By default, *Report Designer* creates an expanding group and shows the group in the *Grouping/Sorting* tab in the *Layout Editor* window.

![](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/layout-editor/expanding-groups/img/en/Expanding-Groups-Process.png)

![](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/layout-editor/expanding-groups/img/en/Expanding-Groups-Process-pt.2.png)*Figure: The process of creating expanding groups in the Layout Editor*

> [!TIP]
> If the row/column is an expanding group, it will be indicated by a small green plus icon ![](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/layout-editor/expanding-groups/img/en/green-plus-icon.png) in the box of the respective row or column.

If the report is generated and an expanding group is *not* created, the report will result in consolidation of all data in the account, as shown in the figure below.

![](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/layout-editor/expanding-groups/img/en/Expanding-Groups-Report.png)*Figure: Report with no expanding group*

On the other hand, if an expanding group is created, the details of the account will be given, as shown in the figure below.

![](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/layout-editor/expanding-groups/img/en/Expanding-Group-Created.png)*Figure: Report with an expanding group*


---

[View this page](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/layout-editor/expanding-groups/)


## In this section


- [Expanding Groups in an Expanding Group](https://docs.vismasoftware.no/onestopreporting/create-templates/report-designer/creating-reports/layout-editor/expanding-groups/expanding-groups-in-expanding-groups/index.md): Create hierarchical reports by nesting expanding groups for deeper data insights.
