Edit

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.

Important

This feature is in preview.

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.

    Screenshot of the pagination control options in the report.

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

    Screenshot of configuring the number of rows displayed per page.

  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.

    Screenshot of configuring row break based on Region.

Customize the report header

  1. Select Header & Footer in the Design ribbon.

  2. Choose from built-in header and footer presets.

    Screenshot of header and footer presets.

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

    Screenshot of the edit icon for changing the header text.

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

    Screenshot of uploading an image to the header.

    Screenshot of the header with an image that was uploaded.

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.

    Screenshot of cells displaying different fill and text colors with a highlight around the format painter button.

  2. Use the column gripper to select Select Header, then apply the desired formatting.

    Screenshot of the Select Header option from within a header cell.

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

    Screenshot of the Row Highlight option in the Design tab of the menu ribbon.

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.

    Screenshot of the Notes button in the Home tab of the menu ribbon.

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

    Screenshot of the Notes Column option expanded from the Notes button.

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

    Screenshot of the Footnote option expanded from the Notes button.

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

    Screenshot of the Report Summary option expanded from the Notes button.

Reorder columns

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

Screenshot of reordering a column in the report.