Custom reports

From MoodleDocs

Custom reports

Formerly a feature of Moodle Workplace TM, the Report builder feature allows administrators to create and share custom reports. This page is about the custom reports feature in Moodle LMS. For the Workplace version see Report builder

Custom reports introduction

4.2 Custom report improvements

New feature
in Moodle 4.2!

4.2 improvements include:

  • Comments and user badges as data sources.
  • Filtering by last, next, current hour.
  • Filtering completion by time enrolled, started, reaggregated.
  • Course overview files available to include in course reports.


With new report sources now available, the complete list of report sources is as follows:

  • Badges
  • Blogs
  • Cohorts
  • Comments (New in 4.2)
  • Course participants
  • Courses
  • Files
  • Groups
  • Notes
  • Tags
  • Task logs
  • Users
  • User badges (New in 4.2)

Create a report

Note the tabs at the top: Edit, Audience, Schedules and Access:

  1. Click New report , give it a name and select your source - whether you want to report on courses, a cohort or specified users.
  2. Click Save. Depending on your source, you will be presented with columns relevant to the data you want. For example, clicking 'courses' will then show categories, course short and full names and ID number.
  3. Remove any columns you don't want and add columns which you do want.
  4.  Note the options for Conditions, Filters, Sorting and Card view on the right.
  5. Preview your report by clicking the Preview button top right.

Give access to reports

From Audience you can select a system role, cohort or manually selected users by clicking the + against who you want and then saving your choice.

You can check the actual users from the Access tab. If you have chosen the system role of Manager, then the Access tab will show you the names of any Managers you have on your site.

Schedule reports

Once you have created a report and decided who has access, you can schedule it from the Schedules tab. The recipients will receive the report via email.

  1. Click New schedule;
  2. Give it a name and choose its format ( .csv by default);
  3. Decide when the report will first be sent out and how often to send it.
  4. The audience will already be selected if you have defined your audience.
  5. If desired, you can add a message to the recipients.
  6. In Advanced, decide what to do if there is nothing to report.

See also

Custom report settings