> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Add elements and data to a report

> Add elements and data to Sigma reports. Build report content and paginate tables and pivot tables for clearer, easier-to-read exports.

Once you have [created a report](/docs/create-and-edit-reports), you can add elements and data to start building out your report. After adding data, you may also want to paginate table elements for ease of use and understanding. This document covers how to add elements to your report, and paginate tables and pivot tables.

Once you have added elements to your report, you may want to further customize element size and formatting. See [Customize report settings and themes](/docs/customize-report-elements-settings-and-branding). For more information on reports in general, see [Reports overview](/docs/reports-overview).

## User requirements

* To add elements to a report, you must be assigned an [account type](/docs/account-type-and-license-overview) with **Create, edit, and publish reports** permission. See [Account type and license overview](/docs/account-type-and-license-overview).
* You must be in **Edit** mode.

## Add elements and data to a report

Each report page provides a canvas on which you can add and arrange elements. You can add a variety of different element types:

* Data elements, like tables, charts, and pivot tables. See [Create a data element](/docs/create-a-data-element).
* Input elements, like empty or linked input tables. See [Intro to input tables](/docs/intro-to-input-tables).
* Control elements, like filters and inputs. See [Intro to control elements](/docs/intro-to-control-elements).
* UI elements, like text, images, embeds, dividers and page numbers. See [Intro to UI elements](/docs/intro-to-ui-elements) and [Edit page order, visibility, and numbers](/docs/edit-report-page-order-visibility-and-numbers).

Once you have added elements to a report, you can format them to meet your reporting and branding needs. See [Format report elements, themes and branding](/docs/customize-report-elements-settings-and-branding).

## Paginate or collapse data tables in a report

Make your data easier to navigate by paginating table and pivot tables. There are two ways to paginate data tables:

**From the table element**:

1. Select your desired table.
2. At the lower right corner of the table, select **Expand table**.
3. To collapse the table, select **Collapse table**.

**From the editor panel**:

1. Select your desired table.
2. In the **Format** tab of the editor panel, open the **Size** section, then select **Expand table rows**.
3. To collapse the table, unselect the **Expand table rows** checkbox.

### Pagination limitations

* Tables and input tables can be paginated up to 10,000 rows:
  * This limitation applies to how many rows are rendered in the report. All operations (like filtering, formulas, summaries, and any child element interactions) are performed on the entire dataset.
  * Report exports will display up to 10,000 rows of data per table/input table.
* Only vertical pagination of data tables is available. Horizontal pagination is not supported.

## Related resources

* [Tutorial: Build and export a sales report](/docs/tutorial-build-and-export-a-sales-report)
* [Create and edit reports](/docs/create-and-edit-reports)
* [Edit report page setup, headers, and footers](/docs/edit-report-page-setup-headers-and-footers)
* [Customize report settings and themes](/docs/customize-report-elements-settings-and-branding)
* [Customize text typeface, size, and style in reports](/docs/customize-text-typeface-size-and-style)
* [Customize element size, position, and layering](/docs/customize-element-size-position-and-layering)
* [Share and export reports](/docs/share-and-export-reports)