# Formatting Tools

To access formatting tools, click the **settings** button.

<figure><img src="/files/IT2V4yWKR7ErBdgskDJQ" alt=""><figcaption></figcaption></figure>

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

## **Show Grand Total**&#x20;

Enabling this option will give you the total of each numerical field in the last row of the report. **Enable** this option b going to settings ![](/files/jIA6UwOaDY5fbornrK0X)

<figure><img src="/files/0stuHONAsT2v2VoGwuxR" alt=""><figcaption></figcaption></figure>

## **Show Subtotal**&#x20;

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.

Go to **report settings** and **enable the subtotal**

<figure><img src="/files/DKNr9js0brQ6LmrCbT9S" alt=""><figcaption></figcaption></figure>

Here are a few examples of subtotal:

:heavy\_check\_mark: Subtotal by **Order**&#x20;

<figure><img src="/files/b3RTMiUiN6RxBB7Ner3Y" alt=""><figcaption></figcaption></figure>

Having the **'Order'** in the **first column** is **essential** for Sub-total to work.

:heavy\_check\_mark: Subtotal by **Order Date** :calendar:&#x20;

<figure><img src="/files/oMHYC4FgBJCiHoilesXi" alt=""><figcaption></figcaption></figure>

Similarly, having the **order date** in the **first column** is a **necessary requirement** for the Sub-total feature to work. Learn how to re-arrange fields by clicking [here.](/kb/reports/customized-reports.md#steps-to-create-customized-reports)

## **Show Grand total on top**

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

<figure><img src="/files/bTHCIbLObzDcRvJs1Rpq" alt=""><figcaption></figcaption></figure>

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

## **One-line Summary**&#x20;

When **One-line Summary** 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: One-line Summary by **Order Date**

<figure><img src="/files/2vboWxdaPrDroYiN0jiT" alt=""><figcaption></figcaption></figure>

Having the **order date** in the **first column** is a **necessary requirement** for the Sub-total feature to work. Learn how to re-arrange fields by clicking [here.](/kb/reports/customized-reports.md#steps-to-create-customized-reports)

:heavy\_check\_mark: One-line summary by **Product Title**

<figure><img src="/files/I5FlnAwV382FpQRdepFj" alt=""><figcaption></figcaption></figure>

Similarly, having the **'Product Title'** 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 an individual transaction.

<figure><img src="/files/sBEK8xiUX9uCJCIM4WXs" alt=""><figcaption></figcaption></figure>

As you can see above, that 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.

## **Report Name for PDF Header**&#x20;

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_sve3hQeu11jT0_8Oq)

## **Select Currency Format**&#x20;

Choose from the available currency to add symbols to the numerical field that includes values of money.

<figure><img src="/files/sIpRBE9OgwLha8pDjo5F" alt=""><figcaption></figcaption></figure>

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


---

# 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.dataexport.io/kb/reports/additional-settings.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.
