> 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

The reports can be altered based on your requirements using our formatting tools.

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

<figure><img src="https://791683593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN38pxrmSRWq3e_Evi%2Fuploads%2FligtpF5odwg72elxa9gO%2FFormatting.gif?alt=media&amp;token=3131a8ed-e575-4ff9-9717-b1082cee47b3" 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 ![](https://791683593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN38pxrmSRWq3e_Evi%2Fuploads%2Fzjbw4Gqn9gKU8BU0JSpS%2Fimage.png?alt=media\&token=931d2457-7d2e-463f-961e-d0f334d682bb)

<figure><img src="https://791683593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN38pxrmSRWq3e_Evi%2Fuploads%2FqSBKEj1TxZiLsezuYWG0%2Fimage.png?alt=media&amp;token=54ab927a-1d3f-40fb-b0bd-216a33ecc1f7" 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="https://791683593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN38pxrmSRWq3e_Evi%2Fuploads%2FkHJ0RbDCjdx4h0KMYq6U%2Fimage.png?alt=media&amp;token=1c1ce988-3a99-49c9-bf18-c47e406723d3" alt=""><figcaption></figcaption></figure>

Here are a few examples of subtotal:

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

<figure><img src="https://791683593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN38pxrmSRWq3e_Evi%2Fuploads%2FQRmYW2QDS5ZpblmAMTPd%2Fimage.png?alt=media&amp;token=4ab7b529-4eb8-4058-94ae-4462256ea678" 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="https://791683593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN38pxrmSRWq3e_Evi%2Fuploads%2FYPECP9zFVWzgt3Lc41f3%2Fimage.png?alt=media&amp;token=e7cf8d56-baa1-4110-97ea-aee7894d2ca3" 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="https://791683593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN38pxrmSRWq3e_Evi%2Fuploads%2FCh9BYIVQ7Ca7lG2EK9ex%2Fimage.png?alt=media&amp;token=397416bb-a780-4d45-9033-e283358df3bc" 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="https://791683593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN38pxrmSRWq3e_Evi%2Fuploads%2F0N26uwmd6gcmLzoptUIp%2Fimage.png?alt=media&amp;token=8d197580-63dd-42ba-96eb-8f744da8ea1f" 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="https://791683593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN38pxrmSRWq3e_Evi%2Fuploads%2FF30iRW0YacUynu9JyP6m%2Fimage.png?alt=media&amp;token=6c12634d-bf2a-4257-aa19-e08601822d20" 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="https://791683593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN38pxrmSRWq3e_Evi%2Fuploads%2FhQw2GxYJasPXvB6QMrpv%2FDetailed%20Report.gif?alt=media&amp;token=5b8af93a-fa1a-4cae-8d91-4583e2e98717" 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.

![](https://791683593-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MVN38pxrmSRWq3e_Evi%2F-M_stb75_4znETizUvgG%2F-M_sve3hQeu11jT0_8Oq%2Fimage.png?alt=media\&token=6cdc0a26-b2c5-43a0-ba9d-aad6d646350a)

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

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

<figure><img src="https://791683593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN38pxrmSRWq3e_Evi%2Fuploads%2F9Qtug0WOekmG9tEeyx1s%2FCurrency%20symbol.gif?alt=media&amp;token=ed788e2c-b631-4064-9f09-9ab3e88d11af" 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 %}
