Copied!

Build Data Analysis Reports With Form.io’s New Reporting Module

Generate data analysis reports based on submission data across one or multiple Forms and Resources within a Project.

Data Analysis Reports With Form.io Reporting Module

Updated November 11, 2026

Form.io’s Reporting Module builds data analysis reports from submission data across one or more forms and resources in the same project, using the MongoDB aggregation pipeline behind a step-by-step report builder. You can join forms on a shared field, add calculated and grouped columns, and embed the finished report in your own application, where users can filter, sort, and export rows to CSV or PDF. It runs on self-hosted Enterprise deployments with a license that has reporting enabled.

Recently we launched our Reporting Module that lets you create data analysis reports across your Forms and Resources within a project.

To be extra clear, yes, you can generate reports that combine data from multiple Forms and/or Resources.

That means things can get meta real fast.

The one restriction is that it only works with Forms and Resources that are in the same Form.io project.

At this moment, the Reporting Module is only available in Enterprise deployments.

First Real Quick: Custom Reports You Define

The Reporting Module isn’t just a thing that shows you a dashboard of metrics, or even merely a pretty way of looking at form data with some sorting and filtering.

Maybe this is obvious, but it’s worth saying. The module lets you build sophisticated, custom reports that you define.

If you’re thinking: “What exactly do you mean by sophisticated or custom?” Good question. Let me show you.

How Does It Work? Building a Report Step by Step

You’re gonna jump into your project. You’re gonna hit that Reporting option on the left side (it’s labeled Reports in the project sidebar now). Then you’re going to see the sauce.

Form.io Reporting Module report setup with Basic Settings open and tabs for Source Forms, Calculated Columns, Aggregation, Columns, and Control Panel

I won’t get into the nitty gritty here, because we have a helpful guide that shows you how to build data analysis reports, step-by-step.

Essentially you’re going to go through the new, left-submenu like a wizard. Pretty simple.

Here are some key things I want to point out:

  • If you choose multiple sources, you are going to have to decide which form is the Base Form and which is the Joining Form
  • Also if you choose multiple sources, then you need to ensure that each source has at least ONE field each that share the same values (common values).
  • Calculated Columns is where you add a column to represent new data based on a calculation of the source(s) data that you will define. A calculation can be math, but it can be other things like concatenate, etc.
  • Aggregation lets you specify how you want to group things and perform group calculations.
  • Columns is where you specify which columns that you actually want to show in the report.
  • Control Panel is where you decide what controls you want in the user-interface, such as filters and actions. In the current builder, these live on the Reporting Controls and Controls Actions tabs.

Hold up a sec.

In the user-interface? Yes. The default way to interact with any report is embedded in your app or just a single page.

Don’t worry though, in the Control Panel, you can configure the ability to enable users of the report to export and download to CSV or PDF. That’s an example of an action.

That’s like, everyone’s first question.

What Can You Do With The Reporting Module?

To begin, think of it as if you’re manipulating the data in a spreadsheet. Except you don’t have to export it to a spreadsheet or CSV.

The Form.io Reporting Module lets you build reports that will continue to function and incorporate new data that’s added over time to the relevant Forms and Resources. It works with live data.

The Reporting Module is like having a data analysis reports engine that lets you spin up a new, miniature, interactive report “app” any time you want.

Some basic things you can do are:

  • Perform math calculations for finance, accounting, etc.
  • Sort and filter data for preferred viewing
  • Concatenate or split data, e.g. combine a first and last name field together
  • Use booleans (and, not, or) to compare data in new ways for deeper insights
  • I’m only scratching the surface

The Form.io Reporting Module is built on top of the MongoDB Aggregation Pipeline which has a HUGE set of features and powerful operators waaaaayyyy beyond what I mentioned above. The module puts a selection of those operators into its builder, so you can build some wild (if you want) reports.

How the Reporting Module Works Today

The basics above still hold. Here’s what the current Form.io docs add, for anyone setting up reports now:

  • What you need. A Form.io Library License with the Reporting Module enabled and formio-enterprise v8.4.1 or later. Reporting is for self-hosted Enterprise deployments and isn’t available on the hosted portal at portal.form.io. Once it’s enabled, a Reports section appears in the project sidebar.
  • Live data shows up where you embed it. The portal preview shows the report’s structure without fetching submissions. To see live data, install the @formio/reporting npm package and call Formio.Report.create with the report’s URL or its JSON. Your code can listen for events such as rowClick, rowSelectChange, and page.
  • The builder tabs. Source Forms, Calculated Columns (operators such as Concatenate Strings, Date Difference, Divide, Multiply, Summarize, Array Size, and date parts like Month Number and Year), Aggregation (Count, Sum, Average, Min, Max), Columns, Reporting Controls for filters, and Controls Actions for Export CSV, Download PDF, or a custom JavaScript action that runs on the selected rows.
  • Joins use a Base Form and a Joining Form. You pick a connecting field on each, and the values have to match. If the field stores a whole object, such as a selected resource submission, you set the path to the value, for example _id.
  • Permissions decide who sees what. Report viewers need Read All at the project level, plus Read All Submission on the Reporting UI resource and on every source form in the report. Without access to one of the source forms, the report won’t load its data.
  • A few limits to plan for. A report covers one project. Date operators need the Date/Time component, because the Textfield with a calendar widget saves dates as strings. Filter, column, and sort choices are saved in the browser’s local storage. Fields inside Edit Grids and Data Grids are supported as of API server 9.3.0, so check your server version.

Sources: the Form.io Reporting Module guide, Data Analysis Reports: MongoDB Aggregation Pipelines Through a Visual Interface, and MongoDB’s aggregation pipeline docs. Keep reading: Model Data In A Schema-Less Data Environment and MongoDB: The Zerg Approach Database Scaling.

Who Is The Reporting Module For?

This is for any data-driven organization that wants the ability to build robust data analysis reports that function with live submission data within their forms without having to deploy a new tool or integration just to make sense of the data they’re collecting.

Form.io is your forms, your data management, and your reports in one platform, deployed in your environment.

If you’re interested in the Reporting Module, send us a message or:

Published by

Form.io Wizard
Content Writer

Long time platform user. Runs multiple production applications with a Form.io backend. "Form.io cleans up all the dirty work and does it for you." Deploy forms like its auth or file storage, stop reinventing the wheel. Forms as the UI, the data model, and the API model. Middleware Mafia.

Published by

Form.io Wizard
Content Writer

Long time platform user. Runs multiple production applications with a Form.io backend. "Form.io cleans up all the dirty work and does it for you." Deploy forms like its auth or file storage, stop reinventing the wheel. Forms as the UI, the data model, and the API model. Middleware Mafia.

LighthouseHQ Case Study: Digital Transformation
Get Answers

Need More Answers?

Ask and we'll get back with you in 1 business day.

Contact Us

Send us a message to contact support or ask a question.

Schedule a meeting

Open Source Platform

Read our FAQ to find out what exactly is Open Source

View the Platform Documentation

View the API Documentation

View the Open Source Code

Learn More

Learn How It Works

Read the Release Notes

Discover Industries that use Form.io

Read our Blog