---
title: Table Builder
description: "To create a structured report interface by extracting fields from one or more tables. It creates an Excel table of data and can easily add an Excel PivotTable or PivotChart with table builder. ![Table Builder](https://globaldata365.com/wp-content/uploads/2023/02/0.png) After choosing it from Jet…"
url: "https://globaldata365.com/helpcenter/table-builder/"
updated: "2025-05-16"
category: Jet Reports
tags:
  - jet reports
  - jet reports business central
---

# Table Builder

To create a structured report interface by extracting fields from one or more tables. It creates an Excel table of data and can easily add an Excel PivotTable or PivotChart with table builder.

![Table Builder](https://globaldata365.com/wp-content/uploads/2023/02/0.png)

After choosing it from Jet ribbon, the following window will appear:

![Table Builder](https://globaldata365.com/wp-content/uploads/2023/02/1.png)

 **Looking to simplify financial reporting in Excel?**
[👉 Join our Jet Reports Training](https://globaldata365.com/jet-reports-training/) and learn to create real-time, dynamic reports with confidence.

### Starting with Table Builder

 

You can click **Add Table** button and search for a table of your own choice. For example, in this case we have added the **Cust. Ledger Entry**table.

![](https://globaldata365.com/wp-content/uploads/2023/02/image-12.png)

You can search for different fields from the table and add them.

 

![Table Builder](https://globaldata365.com/wp-content/uploads/2023/02/image-13-1024x727.png)

Table builder is known for adding fields from multiple tables. Therefore, we are going to add the **Customer**table as well. You can observe the two tables are linked together using the **Customer No.**field.

 

![Table Builder](https://globaldata365.com/wp-content/uploads/2023/02/image-14.png)

After adding fields from both tables, you can edit the names of fields and change their order by dragging them forward or backward.

![Table Builder](https://globaldata365.com/wp-content/uploads/2023/02/image-15.png)

Finally, you can add filters to your table and check **User Defined** to add them as [Report Options](https://globaldata365.com/helpcenter/report-options/).

![](https://globaldata365.com/wp-content/uploads/2023/02/image-16.png)

Table builder provides you the option to save the report unlike Report Options. Press **OK** and Jet Reports will show you a prompt to save the report.

 

![Jet reports Table builder](https://globaldata365.com/wp-content/uploads/2023/02/8-1024x727.png)

The basic structure of a table builder report will be shown in the excel worksheet.

 

![Excel](https://globaldata365.com/wp-content/uploads/2023/02/9-1024x499.png)

You can run the report and the data will be shown in an Excel table.

 

![Excel](https://globaldata365.com/wp-content/uploads/2023/02/10-1024x364.png)

All fields will be displayed, and you can summarize them with **Pivot table** option present in the Table Design ribbon.

 

![Excel](https://globaldata365.com/wp-content/uploads/2023/02/11-1024x517.png)

A pop-up will appear asking to select the table and the worksheet to display the pivot table. After making the required changes, select **OK.**

![](https://globaldata365.com/wp-content/uploads/2023/02/12.png)

You can select different fields as rows and columns for the Pivot table. Furthermore, you can apply filters to the pivot table as well.

![](https://globaldata365.com/wp-content/uploads/2023/02/13.png)

At the top, you can select the option for creating a **Pivot Chart** to visualize your data.

![](https://globaldata365.com/wp-content/uploads/2023/02/image-17.png)

Create different charts and sort the data inside a pivot chart. You can select different kinds of visualizations to view your data.

![](https://globaldata365.com/wp-content/uploads/2023/02/14.png)

#### If You Need Any Help, [Contact us](https://globaldata365.com/contact/) Now!

[wpforms id="13267"]