Skip to main content

Table & Downloads

This section includes settings for the report table and for downloading the report data.

Title​

Check this box to include a title at the top of the report, and specify a title in the provided field. The following shortcodes can be included in titles: [preset] (report name), [start] (report period start date), [end] (report period end date, or add a custom format), and [created] (date that the report is run). Any of the date-based shortcodes can include a second parameter specifying the date and/or time format, in a format supported by the PHP date() function; for example: [start Y-m-d H:i:s]. The start and end timestamps used here for display are both inclusive.

Show column names​

If checked, the first row of the report will contain the field names.

Show column totals​

If checked, the last row of the report will contain totals for the fields that have the Total checkbox checked.

Sort By​

Select the column and order to sort by. The report preview and enhanced HTML formats allow you to change the sort order after the report is run.

Download Format​

The following formats are support for downloads:

  • CSV: The field separation, surrounding, and escaping characters can be customized depending on the requirements of the software that will be reading the file.
  • XLSX Pro: Excel format (see the Compatibility page for information about hosting requirements for this format support).
  • HTML Pro: A basic HTML table.
  • HTML (enhanced) Pro: An interactive HTML table, allowing for searching, sorting, and pagination.

Download Filename Pro​

Specify a filename for the report download, without the extension. The following shortcodes can be included in filenames: [preset] (report name), [start] (report period start date), [end] (report period end date, or add a custom format), and [created] (date that the report is run). Any of the date-based shortcodes can include a second parameter specifying the date and/or time format, in a format supported by the PHP date() function; for example: [start Y-m-d H:i:s].

Row count​

Limit the number of rows displayed or exported in the report to a maximum row count. This setting is useful for showing data on the top 10 products, for example. The totals row, if enabled, will show totals for all rows of the report even if some rows are hidden by this setting.

Report CSS Pro​

Change the appearance of HTML-formatted reports using CSS. For security reasons, this setting is only available for WordPress users with the edit_theme_options capability.