Report Editor



Explanation of all settings

Explanation of all settings

Written By: Marvin Hödlmoser

Last Updated on September 10, 2023

Report Settings


Choose from this Storage options:

  • DataChamp

  • DataChamp - Feed

  • Google Drive / Google Sheets

  • Dropbox

  • FTP

  • FTP 2

Note If you indent to use Google Drive, FTP or Dropbox - please configure your storages first.

Export Mode

Choose from these export modes:

  • Items

    • Standard: All items that match the filter criteria are exported each time the report is run

    • Incremental: Only items that match the filter criteria and were not exported in a previous run are exported

  • Lines

    • Standard: For each sub item e.g. order lines in orders, a separate line is inserted

    • Compress: Sub items e.g. order lines in orders are inserted in a single line

    • Fill: Like "Standard" but values of the main item are copied in each line e.g. "Order note" is inserted for each order line

    • Duplicate by quantity: Sub items e.g. order lines are duplicated based on the quantity. So for a single order line with a quantity of 5, 5 lines are created

File Type & File Name

Choose between these File Types:

  • Excel

  • CSV

  • TXT

When using Google Drive / Google Sheets as Storage you will see this additional option:

  • How to write data to Google Sheets

    • Overwrite

    • Append

    • Add sheets

    • Create new file

You can also use this function within your file name: "addDays(dateformat, number of days)":

CSV - Encoding, Delimiter and Quote

These are the available options when using CSV file type:

  • Encoding

  • UTF-8 (Default)

  • UTF-8 with BOM

    • ASCII

    • CP1252 (Windows-1252)

    • ISO-8859-1

    • ISO-8859-8

    • Shift JIS

  • Delimiter

    • , (Default)

    • ;

    • tab

    • |

  • Quote

    • " (Default)

    • '

    • none

    • " (forced)

  • Line break

    • LF (Mac | Linux | Unix)

    • CRLF (Windows)

File Name

User-defined file names can be used.

Please use one of this placeholders:

DataChamp will show a preview of your customized file name: