---
title: "Report Formatting"
canonical: "https://wiki.yellowfinbi.com/space/yfcurrent/2204603/Report%20Formatting"
format: markdown
---
## Overview
> Macro (styleclass)
>
> [Report Formatting#top](https://yellowfin.atlassian.net/wiki/spaces/yfcurrent/pages/2204603/Report+Formatting#top)
The Report format tab contains a number of sections that you can use to format you report.
Each of these sections is described below.
Data
| **Option** | **Description** |
| --- | --- |
| **Style** | To format the data values contained in your report select the custom style option and apply the font, size etc that you wish to use. |
| **Row Shading** | Selecting Alternating row shading will change the shading for every second row of data in your table report. |
| **Alternate Row Colour** | Choose the colour you wish to apply for the alternate row shading. |
| **Row Highlight** | Use default or custom formatting to apply a row highlight when the user hovers the mouse over the report. |
| **Row Highlight Colour** | Provides the row colour as a mouse rolls over it making it easy to identify rows in very wide reports. |
| **Report Header Lock** | This locks the headers of report tables in place even if they are scrolled out of view. |
| **Header Lock** | This keeps the Headers of the table (either Column Titles or Row Titles) in place when the report scrolls on the dashboard. (This works only for dashboard reports.) |
| **Column Lock** | This keeps the first column of the table displayed when horizontal scrolling is used on the dashboard. |
| **Enable Field Customisation** | When toggled on, the Customise Columns icon will be shown.
This allows column reordering and hide/show of optional fields. |
| **Cell Height** | Define the height of the table rows in pixels if desired. (Optional) |
| **Cell Padding** | Define the space between the text in each cell and the cell border in pixels if desired. (Optional) |
| **Cell Spacing** | Define the space between each cell in pixels if desired. (Optional) |
| **Records Per Page** | Define the number of rows displayed on each page of the report.
If you have a very long report you can break the report into smaller pages by setting the records per page limit. For example if your report has 200 records in it and the Records Per Page is set to 50 you will have 4 pages in your report and a scroll option to navigate through them.
This is also available for section reports but is treated differently – in this case you would edit the section and apply the break on a specific section. |
| **Page Slider** | Specify the placement of the page slider, you can choose to display it either above the table, below the table, or in both positions simultaneously. |
Column & Row Headings
| **Option** | **Description** |
| --- | --- |
| **Style** | Define styling options for the table headers in this report. This covers the font face, font size, font colour, font style, and alignment. |
| **Wrap Text** | Wrap long header text across multiple rows. |
| **Background Colour** | Define the header background colour. |
| **Header Height** | Define the height of the table headers in pixels. |
| **Header Padding** | Define the space between the text in each header cell and the cell border in pixels. |
Border
| **Option** | **Description** |
| --- | --- |
| **Position** | Define where borders should be displayed around the outside edges of the table. |
| **Colour** | Define the border colour for the outside of the table. |
| **Width** | Define the width of the border to be displayed around the report Title & Description. |
Title & Description
| **Option** | **Description** |
| --- | --- |
| **Style** | Define styling options for the table headers in this report. This covers the font face, font size, font colour, font style, and alignment. |
| **Display Title** | Define styling options for the Title of this report. This covers the font face, font size, font colour, font style, and alignment. |
| **Display Description** | Define styling options for the Description of this report. |
| **Border Style** | Define the style of border to be displayed around the report Title & Description. |
| **Border Width** | Define the width of the border to be displayed around the report Title & Description. |
| **Border Colour** | Define the colour of the border to be displayed around the report Title & Description. |
| **Background Colour** | Define the background colour of the report Title & Description. |
Header & Footer
| **Option** | **Description** |
| --- | --- |
| **Style** | Define the Header & Footer contents specifically for this report, or inherit the default options defined in Administration. |
| **Header Options** | Select components to place in the left, centre, and right header areas. |
| **Footer Options** | Select components to place in the left, centre, and right header areas. |
Table Sort
| **Option** | **Description** |
| --- | --- |
| **Column (1, 2, 3, etc.)** | Select a field to sort by. When using multiple fields, the sorting will use Column 1, then Column 2 within Column 1 sort, then Column 3 within Column 1 and 2 sort, etc. |
| **Sort Order** | Sort in Ascending or Descending order. |
| **User Sort** | Allow or prevent the user from defining their own sort when viewing the active report. |
| **Perform Sort at Datasource** | When toggled Off, the result set will be sorted after it is returned from the data source..
When toggled On, report sorting will be pushed to the data source on relational databases. This will use an ORDER BY to order results, allowing ordered results to fit inside the report row limit. |
**Note:** applying sorting to any column through the [Column Formatting](https://yellowfin.atlassian.net/wiki/spaces/yfcurrent/pages/2197024) menu or Table Preview will remove the sorting defined here.
> Macro (styleclass)
>
> [Report Formatting#top](https://yellowfin.atlassian.net/wiki/spaces/yfcurrent/pages/2204603/Report+Formatting#top)