---
title: "Formatting the Report Table"
canonical: "https://docs.rubiconwater.com/space/RptNC/1978796270/Formatting%20the%20Report%20Table"
format: markdown
---
> Macro (toc)

# Format the Borders and Set the Table Position

Set table position and apply borders on the **Table > Heading** tab.

## Set the border colour for the table

Click the **Border Color** button to open a colour chooser and choose a colour.

## Set the horizontal position of the table on the page

Choose the table **Alignment**.

> ℹ️ **Note**
> ℹ️ 
> ℹ️ If you do not specify the column widths, the table will fill the page.

# Specify the Column Widths

By default, table columns will all be the same width and will fill the page in printed output. You can also specify the exact width of each column from the **Table > Columns **tab.

1. On the Table > Columns tab, select the column you want to change and click **Modify** to display the column properties screen
2. Set the **Width**.
3. Click **Save** to save your changes.

---

# Formatting Table and Column Headings

Format report table headings on the Table > Heading and Table > Columns tabs

## Setting the heading text

- To set the TABLE heading, on the Heading tab enter the heading text in the **Title** field.
- To set the COLUMN heading, on the Columns tab select the column whose heading you want to set. Click **Modify** to open the column properties window and enter the heading text in the **Header** field.

### Using dynamic column headers

Select **Use Dynamic Column Headers** to use the contents of the first data row as the table header. Note that this applies only to rows containing bound data.

## Formatting the heading text

1. On the** Heading** tab, click the **Format** button beside the heading that you want to format. This opens a formatting screen for that element.
  - To format the table heading, click the button beside the **Title** field
  - To format the column headings and header row, click the button beside the **Table Header** field
2. In the formatting screen set the:
  - Font, font size, font color and font style.
  - Vertical and horizontal alignment of the text.
3. Click **OK** to save your changes.

## Setting the background colour

To set the background colour, click the **Background** button to open a colour chooser, and choose a colour. This sets the colour for:

- The table header
- The header row
- The table footer

---

# Hiding and Removing Columns

Remove and hide columns on the Table > Columns tab.

> ℹ️ **Note**
> ℹ️ 
> ℹ️ Hide a column rather than removing it if you need to use the column data in a calculated column.

## Hide a Column

1. On the Table > Columns tab, select the column that you want to hide and click **Modify**.
2. In the Add Column screen, select the **Hidden Column** checkbox.
  - A hidden column is marked in the column number field by square brackets: [4]

## Remove a Column

On the **Table > Columns **tab, select the column that you want to remove and click **Remove**.

> ℹ️ **Note**
> ℹ️ 
> ℹ️ You can restore bound columns by clicking the **Bind Data** button again. However, if you do so any calculated columns you have added will be lost.

---