# Pagination and formatting for Reports

Pagination options let you configure layout, context, presentation, and formatting. These capabilities help ensure paginated reports are well-structured, easy to read, and consistently formatted.

The following sections describe how to use pagination options, such as customizing the header and footer, formatting cells, and creating visual hierarchies in your reports.

#### Configure pagination

1. Go to **Design** > **Header & Footer**.
2. Select **Pagination Controls** and select the pagination style to apply.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2Fwjm80hYAemRd13BQOqlF%2Fimage.png?alt=media&#x26;token=921c40d8-0655-4bef-a605-61e0d06fe01f" alt=""><figcaption></figcaption></figure>

3. Select the settings icon in the footer to configure the number of rows displayed per page.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2FOoD7pmPlW9nPDzbrWXH1%2Fimage.png?alt=media&#x26;token=ebc1ff12-51f8-4ad4-b2f1-3c43c332832e" alt=""><figcaption></figcaption></figure>

4. To show data for a specific dimension category on each page: set **Rows per page** to **Row Break**. Select the dimension category, such as **Region**. This displays data grouped by the selected dimension on separate pages.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2FhSbwLfbxHDUWCHgecwos%2F21.%20row%20break.gif?alt=media&#x26;token=8acd6c7c-34f0-4539-bc9d-a3770c561d03" alt=""><figcaption></figcaption></figure>

#### Customize the report header

1. Select **Header & Footer** in the **Design** ribbon.
2. Choose from built-in header and footer presets.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2F4TqJ0dCQfW31e96jqNns%2Fimage.png?alt=media&#x26;token=e416630d-80bb-4839-bdf6-0ecbb097b31e" alt=""><figcaption></figcaption></figure>

3. Select the edit icon to enter custom header text.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2FJpMiTPvAzDZi1qlMRp3w%2Fimage.png?alt=media&#x26;token=517b9817-2a00-42dc-97f2-8131052c44d7" alt=""><figcaption></figcaption></figure>

4. Use the same icon to upload images to the header.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2FeoWUVMqDnScWXtdaLDXT%2Fimage.png?alt=media&#x26;token=e87ceffc-1980-4f3c-bd9d-1199b0e69b7e" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2F9ewhAYkyJ52h5suA5CWf%2Fimage.png?alt=media&#x26;token=a00bfd26-7eec-43e0-a301-620874d2a956" alt=""><figcaption></figcaption></figure>

#### Format cells and column headers

1. Set the cell background and font color, apply text formatting (bold, italic, underline), and adjust the font type and size. Use **Format Painter** to copy formatting across multiple cells.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2FBSkoIcpNNxNx6G7GcRVP%2Fimage.png?alt=media&#x26;token=03dff7c8-b974-4cc6-978e-2dc0bd8bea41" alt=""><figcaption></figcaption></figure>

2. Use the column gripper to choose the **Select Header** option, then apply the desired formatting.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2FyjLmYCyTIlJWydYr8g52%2F8.%20Header%20formattng.gif?alt=media&#x26;token=1d2ccdb5-14cb-44ff-bd81-538fe70c7efe" alt=""><figcaption></figcaption></figure>

3. Apply banded rows to improve readability by highlighting even and odd rows with different colors.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2FBB0A0yJ7kpx7rglngSx8%2Fimage.png?alt=media&#x26;token=32c89962-96b5-4ae8-9250-d0abf143d729" alt=""><figcaption></figcaption></figure>

#### Add notes and annotations

1. Select a row category, column header, or cell. Select **Notes** > **Add New Note**. Use the rich text editor to enter and format notes. Select Save.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2FiLRcDhq6Ra7yG8kMhju6%2Fimage.png?alt=media&#x26;token=82b69c2f-b065-4ad9-9c6b-f6ee4d7ffc6e" alt=""><figcaption></figcaption></figure>

2. Enable **Notes Column** to enter row-level notes.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2FXF7iPTb7vThN3hN6fSwc%2Fimage.png?alt=media&#x26;token=cc079a5d-8833-400d-9ce0-062ef948b9aa" alt=""><figcaption></figcaption></figure>

3. Enable **Footnotes** to view all cell, row, and column-level notes entered in the report.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2FiWwogPhqMr0mb5n9948V%2Fimage.png?alt=media&#x26;token=38243484-1230-49e1-ad81-bd750f158363" alt=""><figcaption></figcaption></figure>

4. Go to **Notes** > **Report Summary** to enter annotations at the report level.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2Fky7zIqIWdyM1EEGSL2JY%2Fimage.png?alt=media&#x26;token=8c61560f-dfbe-4f13-8ff7-f658364bfe10" alt=""><figcaption></figcaption></figure>

#### Reorder columns

To reorder columns in your report, hover over a column and drag the column gripper to the desired position.

<figure><img src="https://2715773316-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXaNsuBB3HcAa0WUQhDTv%2Fuploads%2F4HlnHA2irXqwYsuYau5D%2F19.%20Reorder%20columns.gif?alt=media&#x26;token=fe7f3f43-e275-4640-9d2f-4c479bf68f59" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/intelligence-sheets/how-tos/pagination-and-formatting-for-reports.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
