To create a custom report, login as administrator and from your Administration dashboard, visit Reports. Over there select the tab Custom (1). Over there you shall see a tabular list of all available custom reports, or if you do not have any custom reports set up yet the following screen.
Clicking to setup a new custom report will get to you the Custom Report Create page.
Initially you need to provide a title for this report (2). This field is mandatory. The next mandatory field that you need to provide is the Output infomation (3). This field contains information that you might want to report on. Select the information to be produced for each user. Information related to progress, will produce as many entries as the courses assignments per user.
Next you can add rules (4) to better narrow down your report. Select the rules that will define what data is going to be included in your report. After selecting a rule you can specify it further (5).
You can add more than on rules, which you can later remove if you do not need it any more, and while adding new rules you can define the relation this new rule has to the previous one (6) (meaning a logic relation of AND or OR).
You can finally select whether you want this report to be executed periodically or not and set up a schedule for it.
Setting up a schedule for the report will need to you first enable the Scheduled report option (7) and then define when the report is going to run and what is the interval for your schedule. At last you can specify a list of custom recipients for the schedule report by email.
When you are done, click save and you will be presented with the list of users that comply with the rules you have set up and export them to excel.