# 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 ( | )


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.reportpundit.com/knowledge-base/report-creation/report-formatting-tools.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.