# How to write Report with JavascriptTotal Sale and Total Order For per day **URL:** \ **Category:** V5 Question\ **Created:** [August 10, 2017, 6:09am UTC](https://forum.sambapos.com/t/how-to-write-report-with-javascripttotal-sale-and-total-order-for-per-day/15563 "2017-08-10T06:09:18Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\ **Post date:** [August 10, 2017, 11:51am UTC](https://forum.sambapos.com/t/how-to-write-report-with-javascripttotal-sale-and-total-order-for-per-day/15563/2 "2017-08-10T11:51:44Z")
> [@Kyaw](#): > > I write by Java-script for Sale Detail Report and Order Detail Report XML That is not Javascript at all. Not even close. * * * > [@Kyaw](#): > > I have Create XML Report For Excel Report XML is not a native/natural format for Excel. They are not related. If you want to import XML into Excel, it can be done, but you need to research how to do it… > **[Overview of XML in Excel - Microsoft Support](https://support.microsoft.com/en-us/office/overview-of-xml-in-excel-f11faa7e-63ae-4166-b3ac-c9e9752a7d80?ui=en-us&rs=en-us&ad=us)** > > Learn how to use XML in Excel and how it helps make working with diverse data sets easier. * * * > [@Kyaw](#): > > after i open export file in Excel it show like this > > What I wrong in code it show not properly XML is a text file with a particular structure for representing data. You are seeing a text file in Excel. Instead, you should be creating a Data Export for CSV (comma separated values). Excel can read CSV files natively … > [@Data Exports feature](https://forum.sambapos.com/t/data-exports-feature/6945): > > I notice Data Exports feature under Manage \> Reports, but nothing mentioned on the forum about it. What does this do? Can I use it to create CSV exports? Any info much appreciated. Thanks smile EDIT: Ok I notice it exports the report to a txt file. If for example I use the {REPORT INVENTORY} tag I am getting output like this: \>Local Warehouse|| Svedka|4,900|ML Absolute|4,280|ML Belvedere|455|ML Taking same format from the inventory report with the table header [Inventory Report:1,1, 1… > [@Export custom data into csv or txt](https://forum.sambapos.com/t/export-custom-data-into-csv-or-txt/13406): > > Have been asked to export email addresses from customer account data. I can see in the forum it talks about exporting sales info from the database using the data export tool, so I am assuming that we can also export customer records? Not a SQL guy myself, so I wouldnt have any idea where to start. Is someone able to help me here? (btw, I haven’t disappeared, I’ve got a new project on atm {again}) --- _[View the full topic](https://forum.sambapos.com/t/how-to-write-report-with-javascripttotal-sale-and-total-order-for-per-day/15563)._