> For the complete documentation index, see [llms.txt](https://docs.reportpundit.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.reportpundit.com/knowledge-base/report-creation/report-formatting-tools.md).

# Formatting Tools

Click on the '**Formatting**' button to access the formatting tools.

![](/files/mfhzSX4QU41xv2HtvxQi)

![](/files/dDOhKfitJPUlBALFUm9X)

Click on the respective buttons to **enable** the settings. You can enable multiple settings at a time. These are the formatting tools and their functions:

## **Show Grand Total** 

Enabling this option will give you the total of each numerical fields in the last row of the report. This setting is usually enabled by default. 

![](/files/CUYsT9DNOpnEaIpXPlKK)

## **Show Sub-total**

When the subtotal is enabled, the report will give the total of a group of values. The grouping is based on the first column from the left and its common inputs.

{% hint style="info" %}
**Note:** It only gives you the **sub-total of numerical fields.**
{% endhint %}

Here are a few examples.

:heavy\_check\_mark: Sub-total by **Order Date** :calendar: 

![](/files/1whjiNiJZP5xB9DgD7Ky)

Here, the **order date** is in the **first column,** which is a **necessary requirement** for the Sub-total feature to work. Learn how to re-arrange fields by clicking [here.](/knowledge-base/report-creation/customized-reports.md#re-arrange-fields)

:heavy\_check\_mark: Sub-total by **Product Name**

![](/files/A0A9FXs21fiyOWMA6z4D)

Again, having the **'Product Name'** in the **first column** is **essential** for Sub-total to work.

## **Show Grand total on top**

Enabling this option shows the 'Grand Total' on the first row below the fields.

![](/files/FncFVKjH8qoRbjXx4pzd)

{% hint style="info" %}
**Note:** For this option to work, you must enable **"Show Grand Total".**
{% endhint %}

## **Wrap Primary Records** 

When Wrap Primary Record is enabled, all data contained in the first column from the left will be grouped into its common inputs.

Here are a few examples,

:heavy\_check\_mark: Wrap Primary Records by **Order Date**

![](/files/oCTMwSxTcxBaLw3lMLYL)

Here, the **order date** is in the **first column,** which is a **necessary requirement** for the 'Wrap Primary Records' feature to work. Learn **how to re-arrange fields** by clicking [**here**.](/knowledge-base/report-creation/customized-reports.md#re-arrange-fields)

:heavy\_check\_mark: Wrap Primary Records by **Product Title**

![](/files/8jNn070pqCyPQYotLhuH)

Again, having the **'Product Name'** in the **first column** is **essential** for 'Wrap Primary Records' to work.

## Show Detailed Report

When this is enabled, the report will display detailed records by individual transaction.

**For Example:** In a normal report, the transactions are summarized under the respective order dates. But in a detailed report, each transaction is shown in a distinct row along with the exact time of the order.

![](/files/gkVE1ZvaPJZhq2zanJwU)

## **Report Name for PDF Header** 

When you export the report as PDF, the report name appears on the top as the Header as shown below. This option is enabled by default.

![](/files/-M_iAW165kV5mqRLP6Ay)

## Insert Currency Format

Select the currency format to add symbols to currency-related number columns.

![](/files/jUrzWjHCb21FxwOuv1oC)

{% hint style="info" %}
**Note:** This is not a currency conversion tool. It is to be used only to add currency symbols to the reports.
{% endhint %}

## Select CSV Format

 We can enter any delimiter into the CSV Delimiter box, which acts as the separator when we export the file.

![](/files/B8ceMa8GJPqPPzcEHZha)

The most common delimiters are

* Comma ( , )
* Semi-Colon ( ; )
* Tab ( \t )
* Space ( )
* Pipe ( | )