> For the complete documentation index, see [llms.txt](https://docs.dataexport.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.dataexport.io/kb/reports/additional-settings.md).

# 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 %}
