Work with report data
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
- Sort, filter, and search
- Group and pivot data
- Footer aggregations
- Column controls
- Date range
- View scoping
- Export data
- State persistence
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, filter, and search
Sort columns
Click any column header to sort the report by that column. Each click cycles through three states:
- Ascending β Smallest to largest (A to Z for text, oldest to newest for dates)
- Descending β Largest to smallest (Z to A for text, newest to oldest for dates)
- 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.
Footer aggregations
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.