Report builder

From MoodleDocs
workplacelogo.png This feature is part of Moodle Workplace™, which is available through Moodle Certified Partners and Service Providers only.

Icon Report builder.png
The Report builder saves you time by generating reports easily in a drag and drop interface with instant preview, filtering and aggregation of data from various sources. Schedule reports to be sent automatically to different audiences.

Note: Go to the page Custom reports for the Report builder feature in Moodle LMS.

Moodle Workplace offers a powerful custom reporting tool. You can create interactive custom reports using the report builder interface, which provides advanced customisation options.

Moodle Workplace distinguishes between two types of reports:

  • System reports: Pre-defined reports embedded in Moodle Workplace. Every time you see a table that can be interacted with (sorting columns, applying filters, or downloading data in various formats), you are most likely using a system report. They cannot be modified or removed, as various Workplace features depend on them. Examples are the list of custom reports or report schedules.
  • Custom reports: User-generated reports that can be shared with others users, such as managers and trainers.


Moodle Workplace supports two types of reporting data sources: the Workplace database and the Workplace data store. The database stores all Workplace data, excluding files, while the data store is an alternative data source that keeps track of permanent records in Workplace. The following diagram illustrates the high-level elements of the reporting workflow:


Workplace provides a variety of report sources to simplify the use of the report builder. A record source contains a predefined set of fields and relationships that are available when creating a report. Depending on the selected report source, a specific amount of data will be accessible, which can be narrowed down using the following mechanisms:

  • Configuring data fields: Choose which columns to include, such as user name, certification name, and completion status.
  • Applying conditions: Determine which rows to inlcude, for example, all records from a specific department.
  • Access via audiences: Grant report access to sprecific groups, such as all members of a selected cohort.
  • Filters: Allow viewers to select criteria to further reduce the data, for instance, by the level of progress.

A Report and chart block enables you to visualise reports through interactive graphs and tables. Below two sample charts demonstrating some of the tools capabilities:

Report builder - Chart samples.png