xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField Sales & SFACRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
Auto DMSConsumer Goods DMSSales Force Automation (SFA) FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Analytics & Reporting/Reports in xMatix
CONCEPT · Last reviewed

Reports in xMatix

A report in xMatix is a saved query with presentation: which entity it reads, which related entities it joins, which columns it shows, how rows are grouped, summarized and filtered. Nothing is copied or staged — every time a report opens, its query runs live against your organization's data, so what you see is current as of that moment. Reports are built in the report wizard, shared through an explicit visibility list, and can be emailed on a schedule.

The report library

Reports library showing the Favourites, My Reports, Subscribed and All Reports scopes and the folder list on the left, the All Reports table with star and bell toggles, Name, Type, Description, Folder, Created and Created By columns, and the creation actions in the page header (captured before pivot reports were removed and document reports moved to Document Prints)
The report library: scopes and folders on the left narrow the list, the table shows every report you are allowed to see, and the header action starts a new report. Document prints are listed in their own Document Prints area.UI captured
  1. 1

    New report starts a grid report; print layouts start from New document print in the Document Prints area.

  2. 2

    Favourites and Subscribed are your personal flags; My Reports does not yet filter by owner and lists the same rows as All Reports.

  3. 3

    Folders are plain names set on each report (Parent/Child nests them); a report filed in several folders appears under each.

  4. 4

    The star pins a report into Favourites; the bell opens the Subscribe dialog and is filled when a subscription already exists.

  5. 5

    Click the name to open the report in the viewer.

  6. 6

    Row actions: Design (the wizard), Create dashboard, Edit (name, description, folder, visibility) and Delete.

Reports in an app's navigation opens the library. It lists grid reports only — designed documents such as invoices and statements live in their own Document Prints area. The left-hand menu scopes the list — Favourites, My Reports, Subscribed, All Reports — and below the scopes sit the folders, nested where folder names contain a sub-folder. Two pills switch how the folders are classified: By Folder (first, and the default) and By Role. New report in the page header opens the wizard.

The table shows the Report (its name, with the description beneath), Folder (filterable), Created and Modified (each with who did it) and an actions column. Clicking a name opens the report in the viewer. The star before the name adds the report to your Favourites. The row actions are:

ActionWhat it does
SubscribeOpens the Subscribe dialog (filled when a subscription already exists).
DesignReopens the definition in the wizard for editing.
Create dashboardStarts a new dashboard with this report as its first data source.
EditOpens the properties dialog: Name, Description, Folder and Visibility (Only me / All users / Selected users with roles, profiles and teams). This is where a report is shared.
DeleteRemoves the report permanently after a confirmation.

Two things the library does not do. It shows only reports you are allowed to see — a report someone else created and never shared is not listed at all, and neither is a deactivated report. And My Reports does not currently apply an owner filter: it lists the same reports as All Reports, so use the Created column (it names who created each report), not the scope, to find your own.

Reports and document prints

KindWhat it isWhere it lives
Report (grid)An interactive table — sortable, groupable, filterable, with summaries and optional bucketing columns that spread a dimension across columnsReports — operational lists: open orders, overdue invoices, stock by branch, sales by product by month
Document printA designed, paginated layout built in the full report designerDocument Prints — invoice and purchase-order print formats, statements, letters; see Document prints

Pivot reports no longer exist. For a cross-tab, use a grid report with bucketing or a pivot-table widget on a dashboard.

Viewing a grid report

All Delivery Order Report open in the grid report viewer: Total Records and SUM summaries in the header, a group row for one delivery note with its Total Ordered Qty subtotal, nine detail rows with Status, Document Date, Account, Order, delivery dates, Item and Quantity, and the toolbar with search, refresh, expand and collapse, Filters, Columns, Save and the actions menu
A grouped grid report as readers see it: the query has just run against live records, report-level summaries sit above the grid, each group opens with its own subtotal, and the toolbar holds the viewer-side filters, column chooser, Save and the export, edit, clone, subscribe and delete actions.UI captured
  1. 1

    Total Records and the author's summaries (here SUM Quantity and SUM Pending Shipped Quantity) are computed over the whole result, not just the rows on screen.

  2. 2

    A grouped report shows one heading row per group — this delivery note — with the group's subtotals on the right; the arrow collapses it.

  3. 3

    Search and refresh re-run the query; the expand and collapse buttons open or close every group at once.

  4. 4

    Filters adds your own conditions on top of the report's built-in ones and Columns shows, hides and reorders; Save writes the arrangement into the shared report definition for everyone.

  5. 5

    The menu carries Export to Excel, Export to PDF, Edit (wizard), Clone, Add to favourites, Subscribe and Delete.

  6. 6

    Reports open as workspace tabs beside All Reports, so several reports can stay open while you compare them.

Opening a grid report runs its query and loads rows into the table in pages as you scroll, so large reports open quickly. The header shows Total Records and any report-level summaries the author defined (a SUM Quantity, for example); grouped reports show a heading row per group with its own subtotals, and the toolbar's expand and collapse buttons open or close every group at once. The toolbar also offers search, refresh, Filters (your own conditions on top of the report's built-in ones), Columns (show, hide and reorder) and Save.

Save is a shared change, not a personal view. It writes the current column arrangement, grouping, sort and filter state back into the report definition (the toast reads Report saved), so everyone who opens the report next sees what you saved. Use it to tidy a report you own; for a private variation, Clone the report and adjust the copy instead. Unsaved arrangements are remembered only in your browser for the session.

The toolbar's menu carries the report-level actions: Export to Excel and Export to PDF (the current result, with your filters applied), Edit (reopens the wizard), Clone, Add to favourites, Subscribe and Delete. Reports whose author promoted filters show them as a filter bar above the grid, so a viewer can change the period or branch without opening the filter builder.

Document prints

Designed documents are not listed here. They open from Document Prints in the app's navigation, where the server renders them to PDF and shows them in the browser with Print and Export in the viewer toolbar — though most are reached from a record's Print or Preview action; see Document prints.

Folders, favourites and subscriptions

Folders are names stored on the report, not a managed hierarchy: a report's Folder is set in the wizard's Details step or the row's Edit dialog, and a name that does not exist yet creates the folder. The library reads a path as who it is for, then what it is about — Sales Manager/CRM files the report under the Sales Manager persona with a CRM sub-folder, a plain Sales is a flat folder — and one report can be filed under several paths at once without being copied. Marking a report as a favourite pins it into your Favourites scope — the flag is personal, not shared. Subscribing puts the report in your Subscribed scope and emails it to you on a schedule — as PDF, Excel, CSV or embedded in the message body for a grid report; the mechanics, formats and limits are on Subscriptions.

What runs when a report opens

The report's query runs against live records. Two access checks apply: the report itself must be visible to you (active, and shared with you or created by you), and the entities it reads are read as the platform's query layer exposes them. The report's built-in filters and joins define the result set; your own viewer filters narrow it further for you alone. Because the query is defined by the author, the audience you share a report with sees the rows that query returns — a point that matters when sharing a report over sensitive data.

Common questions

Who can see a report I create?

Only you, until you share it. A new report — and a clone of an existing one — starts visible to its creator alone; other users, including administrators browsing the Reports menu, will not see it listed. Sharing is a deliberate act from the row's Edit dialog: everyone, or selected roles, profiles and teams. The full model is in Sharing & access.

Can I start from an existing report instead of a blank one?

Yes — Clone in the report viewer's actions menu copies the definition. The copy belongs to you and starts private, so you can rename it, adjust columns and filters through the wizard, and share it when it is ready, all without touching the original.

What is the difference between deactivating and deleting a report?

An inactive report is hidden from every user's library, including its creator's, while its definition and sharing are kept. The Reports screen has no Active switch, so to withdraw a report from a group without deleting it, change its Visibility instead (see Sharing & access). Existing subscriptions are not paused by deactivation: they keep sending until the subscriber unsubscribes or the report is deleted. Deleting removes the report permanently and ends its deliveries. Before deleting, check whether any dashboard uses the report as a widget source: those widgets lose their data when the report goes.

Does Save in the viewer change the report for everyone?

Yes. Save in the viewer toolbar writes your column, grouping, sort and filter arrangement into the report definition itself, so it is the same as editing the report in the wizard. There is no per-user saved view for reports today; if you want a variation without touching the shared report, Clone it and save your arrangement on the copy.

Why does my report show fewer rows for a colleague than for me?

Usually because the colleague has unsaved viewer filters applied, or because they are looking at a different report of the same name — the library allows duplicate names in different folders. The report's own rows are defined by its query, not by who opens it; if the counts differ with no filters set, compare the two reports' definitions.