Create at least one course in the default category and one course in any other category Create a custom report (Site administration>Reports>Custom reports) from the "Courses" data source, add a course name there and all columns from the "Category" section Preview the report Make sure the report is displayed and all categories are shown Download the following diff to your moodle root folder ( 75285.diff ): diff --git a/course/classes/reportbuilder/datasource/courses.php b/course/classes/reportbuilder/datasource/courses.php index 13dd4edf748..18f983b6388 100644 --- a/course/classes/reportbuilder/datasource/courses.php +++ b/course/classes/reportbuilder/datasource/courses.php @@ -60,8 +60,8 @@ class courses extends datasource { $coursecatentity = new course_category(); $coursecattablealias = $coursecatentity->get_table_alias('course_categories'); $this->add_entity($coursecatentity - ->add_join("JOIN {course_categories} {$coursecattablealias} - ON {$coursecattablealias}.id = {$coursetablealias}.category")); + ->add_join("LEFT JOIN {course_categories} {$coursecattablealias} + ON {$coursecattablealias}.id = {$coursetablealias}.category AND {$coursecattablealias}.id <> 1")); // Add all columns/filters/conditions from entities to be available in custom reports. $this->add_all_from_entity($coursecatentity->get_entity_name()); Open a terminal and apply the diff. git apply 75285.diff Reload the report page and preview the report. Make sure the report does not show category information for the "Default" category and shows it for all others