# Reports

<details>

<summary>Redirecting FAQs</summary>

1. [How do I create a **customized report?**](/kb/reports/customized-reports.md#steps-to-create-customized-reports)
2. [What are the **Pre-Created Reports** that you provide?](https://dataexport.io/report-types)
3. [How do I **select the fields** for my report?](/kb/reports/customized-reports.md#select-fields)
4. [How do I **edit/rename** the fields in the report?](https://dayspring-tech.gitbook.io/data-export/kb/reports/customized-reports#edit-rename-the-fields-in-the-report)
5. [How do I **re-arrange the fields**?](/kb/reports/customized-reports.md#re-arrange-fields)
6. [How do I **hide a field**?](/kb/reports/customized-reports.md#hide-the-fields)
7. [How do I **remove/delete a field**?](/kb/reports/customized-reports.md#remove-delete-the-field)
8. [How do I **select the date range** for the report?](/kb/reports/customized-reports.md#select-date-range)
9. [How do I **use filters** for the records in the report?](/kb/reports/filters-and-sorting.md#table-of-contents)
10. [How do I **sort the fields** in the report?](/kb/reports/sort.md)
11. [How do I **create custom columns**?](/kb/reports/custom-fields.md)
12. [How do I **create a static field**?](/kb/reports/custom-fields/static-field.md)
13. [How do I **add currency symbols** to the report values?](/kb/reports/additional-settings.md#select-currency-format)
14. [How do I **add sub-total** to the records?](/kb/reports/additional-settings.md#show-sub-total)
15. [How do I **save** a report?](/kb/reports/customized-reports.md#save-report)
16. [How do I **clone/duplicate** a report?](/kb/reports/other-features.md)
17. [How do I **delete** a report?](/kb/reports/other-features.md#steps-to-delete-a-report)
18. [How do I **export a report** without scheduling it?](/kb/reports/customized-reports.md#export-report)
19. [How do I **edit the format** **of a field**?](/kb/reports/customized-reports.md#edit-the-format-of-a-field)
20. [How do I create a **Static field with fixed inputs**?](/kb/reports/custom-fields/static-field.md)

</details>

1. Why are my reports **not showing draft orders**?

* Data Export is designed to show only actual orders which are either marked as pending or paid.
* This is to prevent the report from showing incorrect sales, which happens when the draft orders get mixed up with actual order data.
* If you'd like to see draft orders in your report, kindly [contact us](https://dataexport.io/contact/) and we shall enable the option for you from our end.

2. Can I see **payouts in my Sales report**?&#x20;

* Data Export features a separate report type called "Payout" and "Payout Line items" to obtain detailed and accurate information about your payout data.&#x20;
* A Sales report does not contain fields related to Payouts.

3. Which field shows the **timeline comment** data?

* The timeline comments data will be stored under the Order Events section. Hence, we have to create a field for you from our end.
  * Enable Event Sync in the Additional Sync Section of the Account page.
  * Once the sync is completed, get in touch with us and we will create a custom field for you.

4. Which **language** can I use to write functions under Calculated fields?

* We can perform any arithmetic calculations or case statement inside the calculated field using **PostgreSQL.**

5. How do I write a **`CASE`** statement?

* &#x20;The `CASE` statement goes through conditions and returns a value when the first condition is met (like an `if-then-else` statement). So, once a condition is true, it will stop reading and return the result. If no conditions are true, it returns the value in the `ELSE` clause.  If there is no `ELSE` part and no conditions are true, it returns NULL.&#x20;
* `CASE` Syntax

```
CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    WHEN conditionN THEN resultN
    ELSE result
END
```

* **SQL CASE Examples**

```
CASE 
  WHEN [Total Sales] <= 1000 THEN [Total Discounts] * 5
  WHEN [Total Sales] > 100 THEN [Total Discounts] * 10
  ELSE [Total Sales]
END
```

6. Can you include **additional information** about the **orders** and products like,**`metafields`**, **`line_item`** properties in the report?

* **Yes**, we can include additional custom information about the orders and products in the report. Kindly [contact us](https://dataexport.io/contact/), and we shall set it up for you.

7. Can I view **tax collection** by **county**, **city** & **state**?

* Shopify collects various taxes based on the Store delivery **Location Zip**, or rules **customized** & applied for collecting **taxes** by merchants.
* If the store is set to collect **taxes**, **Data Export** will pull the tax information to **deliver the tax** report. Hence, in order to view the **taxes by county**, **city** & **state** the **rule must be applied** in your **Shopify store** to collect these **taxes**.

8. How do I know the **Best-Selling Products** along with their Variant, SKUs, Vendors, and Product types?

* The above report can be viewed using 3 methods :&#x20;
  * **Customized Method:** Create a report customized to your requirements. Select the desired fields, sort the fields, and save the report. [**Click here**](/kb/reports/customized-reports.md) to learn how to create a customized report.
  * **Easy Method:** Use the pre-created report template 'Best Selling Products' which you can find under the 'Product & Variant Reports' section. Manually, select the extra fields which you need and save the report. &#x20;
  * **Easiest Method:** Ask our **Live Human Support,** and we'll be more than happy to get it done for you.

{% hint style="info" %}
:person\_raising\_hand:Have another question not answered in our FAQ?  [Let us know here](https://dataexport.io/contact).&#x20;
{% 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/faq/reports.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.