Moodle Custom Reports is a functionality available to Moodle version 4.0 and up. To create a custom report in Moodle:
Step 1 : Go to Site Administration > Reports > Custom Reports
Step 2 : Click New report, give it a name and select your source (see above).
Step 3 : Click Save. Depending on your source, you will be presented with columns relevant to the data you want in the Report Editor. For example, clicking 'courses' will then show categories, course short and full names and ID number. Remove any columns you don't want and add columns which you do want.
Step 4 : Change the options for Conditions, Filters, Sorting and Card view as required.
Step 5 : Preview your report by clicking the Preview button top right.