Formatting Tools
The reports can be altered based on your requirements using our formatting tools.
Last updated
The reports can be altered based on your requirements using our formatting tools.
Last updated
Click on the 'Formatting' button to access the formatting tools.
Click on the respective buttons to enable the settings. You can enable multiple settings at a time. These are the formatting tools and their functions:
Enabling this option will give you the total of each numerical fields in the last row of the report. This setting is usually enabled by default.
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.
Note: It only gives you the sub-total of numerical fields.
Here are a few examples.
โ๏ธ Sub-total by Order Date ๐
Here, the order date is in the first column, which is a necessary requirement for the Sub-total feature to work. Learn how to re-arrange fields by clicking here.
โ๏ธ Sub-total by Product Name
Again, having the 'Product Name' in the first column is essential for Sub-total to work.
Enabling this option shows the 'Grand Total' on the first row below the fields.
Note: For this option to work, you must enable "Show Grand Total".
When Wrap Primary Record is enabled, all data contained in the first column from the left will be grouped into its common inputs.
Here are a few examples,
โ๏ธ Wrap Primary Records by Order Date
Here, the order date is in the first column, which is a necessary requirement for the 'Wrap Primary Records' feature to work. Learn how to re-arrange fields by clicking here.
โ๏ธ Wrap Primary Records by Product Title
Again, having the 'Product Name' in the first column is essential for 'Wrap Primary Records' to work.
When this is enabled, the report will display detailed records by individual transaction.
For Example: 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.
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.
Select the currency format to add symbols to currency-related number columns.
Note: This is not a currency conversion tool. It is to be used only to add currency symbols to the reports.
We can enter any delimiter into the CSV Delimiter box, which acts as the separator when we export the file.
The most common delimiters are
Comma ( , )
Semi-Colon ( ; )
Tab ( \t )
Space ( )
Pipe ( | )