ZenotiHelp

Work with report data

ZTZenoti Docs Team Updated August 25, 2026 5 min readReference

Reports on the modern reporting platform display data in an interactive grid that you can sort, filter, group, and export. This article explains the data interaction features available across all modern reports.

Note: The features described here apply to reports on the modern reporting platform. Classic reports have a fixed layout with limited interactivity. Each report article identifies which platform the report uses.


On this page


Report grid

When you open a modern report, data loads into an interactive grid with rows and columns. The grid supports pagination with configurable page sizes of 25, 50, 100, or 200 rows per page.

Sort columns

Click any column header to sort the report by that column. Each click cycles through three states:

  1. Ascending β€” Smallest to largest (A to Z for text, oldest to newest for dates)
  2. Descending β€” Largest to smallest (Z to A for text, newest to oldest for dates)
  3. No sort β€” Returns to the default order

Filter columns

Each column header includes a filter icon. Click the icon to open the filter panel. Filter types are context-aware:

Column data type Filter behavior
Text Text search with contains, equals, starts with, and ends with options
Number / Money Range filter with greater than, less than, equals, and between options
Date Date picker with specific date or date range options

Filters are cumulative β€” applying filters on multiple columns narrows the results to rows matching all conditions.

Group and pivot data

Row grouping

Drag a column header to the group bar above the grid to group rows by that dimension. For example, grouping an employee report by center creates a collapsible section for each center with its rows underneath.

  • Grouped views display subtotals for each group on numeric and monetary columns.
  • You can group by multiple columns to create nested groupings (for example, group by center, then by employee).
  • To remove a grouping, drag the column header out of the group bar.

Pivot mode

For supported reports, pivot mode transposes grouped data into a cross-tab view. This is useful for comparing values across two dimensions simultaneously, such as revenue by center and by month.

Numeric and monetary columns display aggregate values in a pinned footer row at the bottom of the grid. Available aggregations include:

  • Sum β€” Total of all values in the column
  • Average β€” Mean of all values in the column
  • Count β€” Number of rows with a value in the column

Footer aggregations reflect the current filter state β€” if you filter the report, the footer updates to show aggregations for the filtered results only.

Column controls

Resize columns

Drag the right border of any column header to adjust the column width. Your width preferences are saved automatically.

Reorder columns

Drag a column header to a new position to rearrange the display order. The new order is saved per user per report.

Pin columns

Pin a column to the left or right edge of the grid so it remains visible while you scroll horizontally. This is useful for keeping identifier columns (such as employee name or invoice number) in view while reviewing data columns.

Show and hide columns

Open the column chooser panel to select which columns are visible. Hidden columns are excluded from exports.

Date range

Every modern report includes a date range selector at the top of the report viewer.

Presets

Preset Description
Today Current business day
Last 7 days Previous 7 calendar days
Last 14 days Previous 14 calendar days
Last 1 month Previous calendar month
Last 2 months Previous 2 calendar months
Last 3 months Previous 3 calendar months
Last 6 months Previous 6 calendar months
Custom Select specific start and end dates using the date picker

The default preset varies by report. Most reports default to Today or Last 7 days.

Custom date range β€” three rules that affect report behavior

When you select Custom, three interaction rules determine whether the report runs correctly.

1. Commit the range before clicking Refresh

The Refresh button remains unavailable until you have selected both a start date and an end date and committed the range. If Refresh appears greyed out after choosing Custom, the date range is incomplete β€” not a fault with the report. Select both dates to enable the button.

2. Select the start date before the end date

In the date picker, always choose the start date first, then the end date. If you click the end date before the start date, the picker resets the range to its default. This is why an end date can appear not to hold β€” the picker interpreted the click as an out-of-order selection and reverted.

3. Ranges wider than approximately eleven months are not rendered in the browser

The report grid does not render results for date ranges that exceed roughly eleven months. If you need data for a period longer than this, use the email export path: click Export, and the file is delivered to your registered email address once it is ready. For details on how that delivery works, see Email delivery for large exports below.

View scoping

Reports support four scope levels that control how broadly the report aggregates data.

Scope What it shows
Organization Aggregated data across all centers the user can access
Zone Data filtered to centers within the selected zone
Center Data for a single selected center
General Default scope that respects the user's current center context

The scope selector appears only when your permissions span multiple centers. If you have access to a single center, the report automatically scopes to that center.

Export data

Click Export to download report data as a flat file.

  • Formats β€” XLSX (default) and CSV.
  • Scope β€” The export includes all rows matching the current filters, not only the currently visible page.
  • Column configuration β€” The export preserves your current column selection and column order.
  • Large exports β€” When the dataset exceeds the inline download threshold, the export is delivered via email instead of a direct download (see below).

Email delivery for large exports

When a report export is too large to download directly, Zenoti processes the export in the background and delivers it via email. The system sends an email with a download link to the user's registered email address once the export file is ready. This allows you to continue working in Zenoti while the export is prepared.

Note: Ensure your registered email address in Zenoti is current so you receive the download link. The email is sent to the address associated with your user account.

State persistence

The modern reporting platform remembers your layout preferences for each report. The following settings persist per user per report across sessions:

  • Column widths
  • Column order
  • Sort state (which column and direction)
  • Applied filters

When you return to a report, your previous layout is restored automatically. This means each user can have their own preferred view of the same report without affecting other users.

Was this article helpful?
Your feedback helps us improve our documentation.